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

17 votes125 views4 answers
Postgres list users
SQL
0 vote106 views1 answer
Select value from previous row in postgresql
SQL
0 vote123 views1 answer
How to close external sql connection in laravel
SQL
5 votes119 views1 answer
Oracle columns in all_tables
SQL
0 vote125 views2 answers
How to get last inserted id in sql server c#
SQL
0 vote125 views1 answer
Apt install sql server
SQL
0 vote119 views1 answer
Sql select by content lenght
SQL
0 vote114 views1 answer
Sql describe
SQL
1 vote120 views1 answer
Mysql get domain from url
SQL
2 votes135 views1 answer
How to select from mssql
SQL