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

0 vote210 views3 answers
Magento 2 order delete from db
SQL
0 vote203 views4 answers
Change schema in sql server
SQL
10 votes229 views2 answers
Select nextval from sequence oracle
SQL
1 vote213 views1 answer
Adding indexing on a db model in mysql using sequelize
SQL
0 vote201 views2 answers
Android sqlite tutorial for beginners
SQL
5 votes208 views1 answer
Commentaire table oracle
SQL
9 votes191 views2 answers
Mac mysql this is incompatible with sql_mode=only_full_group_by
SQL
0 vote216 views1 answer
Nosql vs sql
SQL
1 vote210 views3 answers
Showing all columns in an sqlite table
SQL
0 vote203 views1 answer
C# select Mysql
SQL