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 vote244 views1 answer
Import sql in postgresql
SQL
1 vote229 views1 answer
How to truncate a table in databse
SQL
0 vote250 views1 answer
Python connect to mysql in settings.py
SQL
0 vote219 views1 answer
Postgres add prefix to primary key
SQL
0 vote270 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote243 views1 answer
Illuminate/Database/QueryException with message 'SQLSTATE[42S02]
SQL
0 vote247 views1 answer
SQL query to verify the size of the table
SQL
0 vote229 views1 answer
Python mysql executemany
SQL
5 votes225 views1 answer
Oracle asynchronous query
SQL
0 vote250 views1 answer
Postgresql delete limit
SQL