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 vote130 views2 answers
Select columns from 2 tables with foreign key
SQL
5 votes134 views3 answers
Sql make column nullable
SQL
0 vote147 views2 answers
Dbms transaction tutorialspoint
SQL
0 vote144 views1 answer
Regex any word except sql
SQL
16 votes135 views6 answers
Install sqlite3 python
SQL
0 vote124 views1 answer
Postgresql create user roles
SQL
0 vote148 views1 answer
Mysqli last row
SQL
3 votes127 views1 answer
DB: in eloquent using sql
SQL
6 votes165 views1 answer
Check Table Exists
SQL
0 vote131 views1 answer
Sql count * vs count 1
SQL