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 vote133 views1 answer
Uuid sqlalcomany
SQL
5 votes125 views2 answers
Create table
SQL
0 vote264 views1 answer
Oracle convert int to date
SQL
0 vote133 views1 answer
Table or view does not exist
SQL
0 vote136 views1 answer
How to declare variable date in mysql
SQL
0 vote170 views2 answers
Get value from a table an insert it with other values in another table sql
SQL
-1 vote138 views3 answers
SQL to LINQ converter
SQL
0 vote197 views1 answer
Tsql find procedure with name
SQL
4 votes174 views6 answers
Select sql
SQL
3 votes130 views2 answers
To_char oracle
SQL