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

5 votes344 views1 answer
Sql add column after another
SQL
0 vote334 views1 answer
Mysql cli output to a file
SQL
0 vote313 views1 answer
Uuid sqlalcomany
SQL
0 vote348 views1 answer
Mysql 3 months ago
SQL
17 votes326 views6 answers
Get last record in sql
SQL
2 votes310 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote325 views2 answers
Changes not showing on website server odoo
SQL
13 votes322 views4 answers
Mysql access denied for user 'root'@'localhost'
SQL
0 vote332 views3 answers
Magento 2 order delete from db
SQL
10 votes348 views2 answers
Mysql drop database if exists
SQL