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 vote280 views1 answer
Every Derived yable must have its own alias
SQL
0 vote269 views1 answer
Mysql could not fetch tables
SQL
8 votes301 views4 answers
Reset SQL auto increment
SQL
16 votes282 views1 answer
Mysql smallint range
SQL
0 vote290 views1 answer
Trigger stock phpmyadmin
SQL
0 vote283 views1 answer
Postgres populate table from another table
SQL
1 vote258 views1 answer
Sql week commencing date
SQL
0 vote272 views1 answer
Install sql server in ubuntu 20.04
SQL
1 vote284 views1 answer
Sql order by where condition
SQL
0 vote266 views1 answer
Oracle execute package dblink
SQL