Oracle list partitions

-- Partitions of a table
SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_COUNT, 
       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
FROM DBA_TAB_PARTITIONS
WHERE TABLE_OWNER = 'DSI_TAHITI'
  AND TABLE_NAME = 'COURBE';
-- Subpartitions of a table
SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, 
       HIGH_VALUE, PCT_USED, NUM_ROWS, LAST_ANALYZED
FROM DBA_TAB_SUBPARTITIONS
WHERE TABLE_OWNER = 'DSI_TAHITI'
  AND TABLE_NAME = 'COURBE';

Similar codes

15 votes323 views4 answers
Export mysql db using command line
SQL
0 vote337 views1 answer
Mysql vs sql server performance benchmark
SQL
0 vote321 views1 answer
The report definition has an invalid target namespace 'http://schemas.microsoft.com/SQLServer/reporting/reportdesigner'
SQL
3 votes335 views1 answer
Postgres count distinct
SQL
0 vote328 views2 answers
Postgres default user
SQL
3 votes329 views1 answer
Oracle list dates without weekends
SQL
-1 vote334 views5 answers
Not in sql
SQL
-2 votes309 views1 answer
Remove root password mysql
SQL
0 vote321 views4 answers
Postgresql between month
SQL
3 votes501 views6 answers
Sql unique select
SQL