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 vote337 views1 answer
Mysql in clausule string array
SQL
0 vote313 views1 answer
Sql view index
SQL
-1 vote293 views1 answer
Plsql while
SQL
0 vote335 views1 answer
On sql table data exists
SQL
1 vote376 views1 answer
Postgresql if 0 then 1
SQL
3 votes320 views1 answer
Sql datetime as date
SQL
0 vote392 views1 answer
Com.mysql.cj.exceptions.InvalidConnectionAttributeException more than one time zone. You must configure either the server or JD value if you want to utilize time zone support.
SQL
0 vote312 views1 answer
Drop all procedures sql server
SQL
2 votes371 views1 answer
Show max_allowed_packet mysql
SQL
0 vote317 views1 answer
Sql string length postgresql
SQL