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

-1 vote259 views1 answer
Add column alter table default value
SQL
0 vote261 views5 answers
Sql table intermédiaire
SQL
2 votes257 views2 answers
Checking data type in sql server
SQL
2 votes276 views2 answers
How to import large sql file in phpmyadmin in ubuntu
SQL
16 votes260 views4 answers
Sort by sql
SQL
0 vote286 views1 answer
Shows all databases created by user in ms sql
SQL
2 votes246 views1 answer
Get first 3 letters name in sql
SQL
4 votes287 views1 answer
Mysql delete last row
SQL
9 votes253 views3 answers
Sequence postgresql
SQL
7 votes270 views6 answers
Group_concat mysql
SQL