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 vote178 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
0 vote170 views1 answer
Sqlite higher or equal
SQL
1 vote157 views1 answer
Set id count mysql
SQL
0 vote337 views1 answer
Postrgesql concat 2 columns divided by ;
SQL
1 vote149 views1 answer
Select from one table where not on the other
SQL
0 vote166 views1 answer
What is the use of index in mysql table
SQL
3 votes169 views3 answers
Postgresql random number
SQL
0 vote161 views1 answer
Mysql case when null
SQL
0 vote195 views1 answer
What is default mysql database password in linux
SQL
0 vote216 views1 answer
Postgresql remove new line from string
SQL