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 vote94 views1 answer
Kotlin sqlite delete row
SQL
34 votes114 views6 answers
Install mysql client ubuntu
SQL
0 vote103 views1 answer
Services.AddDbContext DataSource Sqlite
SQL
10 votes100 views4 answers
Join with multiple conditions sql
SQL
0 vote127 views1 answer
SQL SELECT TOP Equivalent in MySQL
SQL
3 votes101 views3 answers
Create a view postgres
SQL
0 vote111 views1 answer
Update view sql
SQL
7 votes102 views4 answers
What is my mysql version
SQL
0 vote104 views1 answer
Grant privileges of databse to user
SQL
0 vote128 views1 answer
Laravel SQLSTATE[HY000] [2002] No such file or directory (SQL: select * from information_schema.tables where table_schema = testDB and table_name = migrations and table_type = 'BASE TABLE')
SQL