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 vote244 views1 answer
Npm ERR! code ELIFECYCLE npm ERR! errno 1 npm ERR! [email protected] install: `node-pre-gyp install --fallback-to-build` npm ERR! Exit status 1 npm ERR! npm ERR! Failed at the [email protected] install script.
SQL
1 vote265 views1 answer
How to remove identity from a column in sql server
SQL
0 vote255 views1 answer
T-sql check if data exists
SQL
4 votes207 views1 answer
And or sql order of operations
SQL
0 vote256 views1 answer
Mssql now diff 90 day
SQL
8 votes283 views6 answers
Sql insert
SQL
0 vote259 views1 answer
Data directory postgresql
SQL
3 votes241 views1 answer
Pl sql check if variable is empty
SQL
0 vote254 views1 answer
Ignore case in string sql
SQL
1 vote240 views2 answers
Mysql spring boot application.properties
SQL