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

-2 votes339 views1 answer
Remove root password mysql
SQL
0 vote406 views1 answer
Osm2pgsql mac
SQL
0 vote366 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote371 views1 answer
Sql declare variable single line
SQL
0 vote342 views1 answer
Mysql select where field like in list
SQL
4 votes339 views1 answer
Sql delete where in select
SQL
1 vote362 views2 answers
Mysql switch case
SQL
1 vote332 views1 answer
Check message id sql server
SQL
0 vote341 views1 answer
Prepared statement mysql java delete selected rows
SQL
4 votes331 views2 answers
Oracle unliock account
SQL