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 vote222 views1 answer
Compress sql file database ubuntu
SQL
0 vote195 views1 answer
Turnicate in mysql
SQL
9 votes196 views1 answer
Mysql check date range
SQL
0 vote185 views2 answers
Plan d'exécution requete oracle autotracer
SQL
0 vote203 views1 answer
Mysql dump for selected row
SQL
6 votes224 views2 answers
Subtr Oracle ?
SQL
1 vote199 views1 answer
Create another table from existing table sql oracle
SQL
0 vote189 views1 answer
Sql grant select only
SQL
0 vote278 views1 answer
Play framework connection via windows sql server
SQL
4 votes191 views2 answers
Postgresql reset sequence
SQL