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

0 vote274 views1 answer
Postgresql delete limit
SQL
1 vote282 views1 answer
Insert pg result of select
SQL
0 vote283 views2 answers
Temp Space
SQL
0 vote266 views1 answer
Mysql wait_timeout
SQL
0 vote249 views1 answer
Mysql command line ubuntu
SQL
0 vote259 views1 answer
Oracle query archivemode
SQL
4 votes252 views1 answer
T-sql get duplicate rows
SQL
0 vote268 views2 answers
Call to undefined function mysqli_fetch_all()
SQL
0 vote274 views3 answers
Sql server obtener fecha en formato dd/mm/yyyy
SQL
0 vote247 views1 answer
Alter precision
SQL