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

7 votes185 views1 answer
Oracle pagination query offset
SQL
0 vote180 views2 answers
Pl sql auto increment
SQL
0 vote197 views4 answers
What is unique key in sql
SQL
2 votes175 views1 answer
Anonymous block plsql
SQL
0 vote179 views1 answer
Pl/sql loop example
SQL
8 votes174 views3 answers
Alter table auto_increment
SQL
1 vote197 views1 answer
Psql connect to another database
SQL
0 vote184 views2 answers
Zsh: command not found: mysq
SQL
57 votes562 views6 answers
Mysql alter table add column
SQL
0 vote129 views1 answer
Ms sql print more than 1 variable
SQL