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 vote113 views1 answer
Create table like sql
SQL
0 vote119 views1 answer
Oracle sql number to varchar2
SQL
0 vote107 views1 answer
Set default value now() date
SQL
1 vote65 views1 answer
Ms sql how to see active job current run time
SQL
0 vote103 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
2 votes104 views1 answer
Oracle calculated column
SQL
0 vote112 views1 answer
Oracle create table auto generated primary key
SQL
0 vote106 views1 answer
Teller stamp , bmo , PDF
SQL
0 vote105 views1 answer
Sql DATE = GETDATE()
SQL
1 vote130 views1 answer
How-can-i-start-postgresql-server-on-mac-os-x
SQL