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 votes175 views1 answer
How to drop a database in sql server when it is in use
SQL
2 votes200 views1 answer
Brew start postgres manual
SQL
14 votes138 views3 answers
This is incompatible with sql_mode=only_full_group_by laravel
SQL
0 vote146 views1 answer
Error: connect ECONNREFUSED 127.0.0.1:5432 at TCPConnectWrap.afterConnect [as oncomplete] (net.js:1148:16
SQL
12 votes163 views1 answer
Run mysql instance in docker
SQL
0 vote174 views1 answer
Create table with timestamp mysql youtube
SQL
1 vote154 views1 answer
Mysql view curren querys
SQL
16 votes149 views4 answers
Mysql import from sql file
SQL
0 vote153 views1 answer
SQL server datetime compare
SQL
6 votes139 views1 answer
Phpmyadmin password root
SQL