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

9 votes131 views3 answers
Mysql run sql file
SQL
0 vote134 views1 answer
Unique index in mysql
SQL
1 vote123 views1 answer
Mysql show table character set
SQL
13 votes116 views4 answers
GROUP BY clause; this is incompatible with sql_mode=only_full_group_by
SQL
39 votes230 views5 answers
Sql drop column
SQL
0 vote127 views1 answer
User has exceeded the 'max_questions' resource (current value: 75000)
SQL
1 vote82 views1 answer
Psql kill pid
SQL
0 vote134 views1 answer
Mysql average from two table
SQL
24 votes127 views6 answers
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
SQL
0 vote125 views1 answer
T sql cursor tr
SQL