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 votes196 views1 answer
Columns Present in a table
SQL
2 votes257 views1 answer
Select a certain number of entries from select mysql
SQL
1 vote260 views1 answer
Sql query row number group by
SQL
3 votes197 views2 answers
Mysql HAVING
SQL
0 vote244 views2 answers
How to retrive image from sql to picturebox usinf image location
SQL
12 votes243 views6 answers
How to install sqlite3 in python
SQL
6 votes196 views1 answer
Oracle desc table primary key
SQL
15 votes351 views3 answers
Postgresql change column type
SQL
0 vote240 views1 answer
Mysql 3 months ago
SQL
-1 vote203 views8 answers
Create Trigger in phpMyAdmin
SQL