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 votes170 views1 answer
Install sqlite npm
SQL
0 vote178 views1 answer
Soql user profile
SQL
0 vote197 views1 answer
Postgresql delete limit
SQL
0 vote191 views1 answer
SELECT statement to find the specific cell in database table
SQL
0 vote169 views1 answer
Oracle INTERVAL DAY to second to number
SQL
1 vote185 views1 answer
How to select multiple columns from different tables in mysql
SQL
0 vote184 views1 answer
Mysql readable output
SQL
0 vote185 views1 answer
Sql server query database space available
SQL
-1 vote176 views5 answers
Online sql to linq generator
SQL
0 vote180 views1 answer
Flask sqlalchemy remove duplicates
SQL