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

0 vote160 views1 answer
Mysql auto increment default value with prefix month and year
SQL
23 votes183 views2 answers
Query to delete a database in mysql
SQL
1 vote184 views1 answer
Create new index takes long time postgresql
SQL
-1 vote175 views3 answers
My sql alter table
SQL
2 votes183 views2 answers
Mysql find max value row
SQL
1 vote183 views1 answer
Sql select whole row max column
SQL
8 votes186 views2 answers
Grant all privileges database postgres to user
SQL
0 vote168 views2 answers
Dbms transaction tutorialspoint
SQL
1 vote176 views2 answers
Mysql: command not found
SQL
0 vote156 views1 answer
How to import sqlite driver class in java using maven
SQL