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 vote376 views2 answers
Sqlalchemy default value for column
SQL
2 votes292 views1 answer
How to delete columns in sql
SQL
1 vote298 views1 answer
Oracle nvl2
SQL
0 vote288 views1 answer
Code to move ietms from one table to another myswl
SQL
1 vote304 views1 answer
T-sql disable system versioning
SQL
0 vote275 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
1 vote293 views1 answer
Code: "ER_TRUNCATED_WRONG_VALUE", errno: 1292, sqlMessage: "Incorrect date value: '2021-03-20T18:30:00.000Z' for column 'mgfdate' at row 1", sqlState: "22007", index: 0, …}
SQL
0 vote280 views1 answer
Populate db from command line postgres
SQL
0 vote320 views1 answer
Mysql convert charset
SQL
0 vote298 views1 answer
Running percentage of total postgres
SQL