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

4 votes347 views1 answer
Oracle table statistics last analyzed
SQL
8 votes367 views1 answer
Today minus 15 days postgresql
SQL
0 vote342 views1 answer
Postgres in operator with comma separated values
SQL
0 vote373 views1 answer
Unable to convert mysql date/time value to system.datetime
SQL
0 vote356 views1 answer
Sql server select value large text
SQL
3 votes327 views1 answer
Mysql UPDate with enner join
SQL
0 vote353 views1 answer
Find and replace database table phpmyadmin
SQL
6 votes398 views2 answers
Foreign key sqlite3 python
SQL
6 votes445 views2 answers
Install psql mac
SQL
0 vote371 views1 answer
Influxdb clone measurement
SQL