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 vote295 views2 answers
SQL Server log file truncate - Source :NAYCode.com
SQL
2 votes329 views1 answer
Ssh mysql port forwarding
SQL
2 votes300 views1 answer
Mariadb JSON_EXTRACT
SQL
0 vote303 views1 answer
Start and stop mysql
SQL
-2 votes321 views2 answers
Union all in sql
SQL
0 vote323 views1 answer
Check user sql password from command line
SQL
0 vote310 views1 answer
Create bdd mysql
SQL
16 votes305 views3 answers
Tsql rename column name
SQL
0 vote293 views1 answer
Get who is hired in specific month in sql
SQL
0 vote317 views5 answers
How to make trigger in phpmyadmin
SQL