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

23 votes201 views6 answers
ER_NOT_SUPPORTED_AUTH_MODE: Client does not support authentication protocol requested by server; consider upgrading MySQL client
SQL
0 vote188 views1 answer
Oracle query archivemode
SQL
8 votes258 views2 answers
Python simple connect to mysql
SQL
1 vote208 views1 answer
Write a query to create an empty table from an existing table?
SQL
0 vote191 views4 answers
Mysql select bottom 10 rows
SQL
3 votes201 views1 answer
Show index table
SQL
0 vote191 views1 answer
Postgresql create table many-to-many
SQL
2 votes203 views1 answer
No data found oracle
SQL
4 votes201 views1 answer
Mysql not equal
SQL
13 votes194 views6 answers
Current date sql
SQL