Oracle list partitioned tables

How to see all table partition in oracle

SELECT * FROM ALL_TAB_PARTITIONS;

Oracle list partitioned tables

-- List of partitioned tables
SELECT DISTINCT P.TABLE_OWNER, P.TABLE_NAME, count(*) AS NB_PARTITIONS, 
	SP.NB_SUBPARTITIONS
FROM DBA_TAB_PARTITIONS P
LEFT JOIN (SELECT DISTINCT TABLE_OWNER, TABLE_NAME, count(*) AS NB_SUBPARTITIONS
           FROM DBA_TAB_SUBPARTITIONS
           GROUP BY TABLE_OWNER, TABLE_NAME, PARTITION_NAME
          ) SP
ON P.TABLE_OWNER = SP.TABLE_OWNER AND P.TABLE_NAME = SP.TABLE_NAME
WHERE P.TABLE_OWNER NOT IN ('SYS', 'SYSTEM')
GROUP BY P.TABLE_OWNER, P.TABLE_NAME, SP.NB_SUBPARTITIONS
ORDER BY P.TABLE_OWNER, P.TABLE_NAME;

Similar codes

2 votes335 views3 answers
Oracle show column of table
SQL
1 vote335 views1 answer
Postgres select as csv
SQL
0 vote329 views1 answer
Postgres declare variable
SQL
0 vote350 views1 answer
Clear query cache sql server
SQL
1 vote326 views1 answer
Error code 1055
SQL
0 vote331 views1 answer
Jdbc sql connection string
SQL
3 votes360 views1 answer
Start mysql server linux terminal
SQL
0 vote392 views1 answer
Mysql delete entire row on condition
SQL
0 vote375 views1 answer
Yesql
SQL
0 vote329 views1 answer
Joins vs includes
SQL