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

53 votes298 views6 answers
Sql server alter column
SQL
0 vote127 views1 answer
Oracle sql copy table without data
SQL
0 vote120 views1 answer
Lost connection to mysql
SQL
1 vote121 views1 answer
Mysql average of multiple columns
SQL
0 vote145 views1 answer
The fetch keyword oracle
SQL
0 vote96 views1 answer
Sql table to store status
SQL
1 vote123 views1 answer
Mysql get latest duplicate rows
SQL
3 votes169 views1 answer
Sql several or
SQL
10 votes110 views3 answers
Join multiple tables sql
SQL
1 vote128 views1 answer
How to check the mysql version mac
SQL