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

4 votes215 views3 answers
Sqlite show columns
SQL
0 vote193 views1 answer
Oracle list partitions
SQL
0 vote187 views1 answer
How to generate ids in sql
SQL
0 vote182 views1 answer
Doesn't have default value mysql
SQL
0 vote191 views1 answer
How to connect sqlalchemy to mysql and deploy it
SQL
0 vote190 views2 answers
How covert into int in maria db
SQL
0 vote216 views1 answer
Client does not support authentication protocol requested by server sqlyog
SQL
0 vote219 views1 answer
Mysql backup query
SQL
31 votes193 views3 answers
SQL Server change column data type
SQL
1 vote191 views1 answer
Operator does not exist: integer = text
SQL