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

-1 vote356 views1 answer
Capitole toulouse
SQL
4 votes373 views2 answers
Installing sql on ubuntu
SQL
7 votes362 views2 answers
Mysql default value
SQL
2 votes383 views1 answer
Oracle list duplicates
SQL
27 votes379 views5 answers
Mysql set password for user
SQL
2 votes361 views2 answers
Run mysql command from bash
SQL
1 vote400 views2 answers
How to install mysql workbench in ubuntu 20.04
SQL
1 vote363 views1 answer
Can not connect to mysql server
SQL
0 vote367 views1 answer
Sql reverse order of results
SQL
1 vote342 views1 answer
Mysql show current queries
SQL