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

3 votes113 views3 answers
Into in sql
SQL
2 votes119 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
0 vote114 views1 answer
Wordpress database query change url
SQL
-1 vote131 views2 answers
Mysql error 1064 you have an error in your sql syntax
SQL
3 votes142 views2 answers
Oracle sql first day of month
SQL
1 vote136 views2 answers
Remove space in mysql
SQL
0 vote158 views1 answer
Store case result sql
SQL
0 vote118 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote150 views1 answer
How to pass list as parameter in SQL query
SQL
0 vote107 views1 answer
Como hacer una consulta de un registro que no esta en una tabla en mysql
SQL