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 vote325 views1 answer
Oracle select partition
SQL
0 vote348 views1 answer
Write SQL in ruby on rails
SQL
0 vote291 views1 answer
Difference between cross apply and inner join
SQL
0 vote303 views1 answer
How to change mysql port in xampp
SQL
1 vote294 views1 answer
Delete mysql from mac
SQL
-1 vote308 views1 answer
Convert google analytics dathourminute to time stamp? sql
SQL
3 votes311 views2 answers
How to start postgresql on windows
SQL
0 vote308 views1 answer
Call procedure in wordpress
SQL
3 votes311 views1 answer
Select without null values sql
SQL
0 vote337 views1 answer
Updating database in sql
SQL