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 vote182 views1 answer
Hou to run job from cmd .exe sql server jop
SQL
2 votes171 views1 answer
Get first 2 letter in sql
SQL
0 vote153 views1 answer
Print orcale
SQL
0 vote171 views1 answer
If exist column in table drop sql query mysql
SQL
0 vote177 views1 answer
How to update sql server version
SQL
0 vote168 views1 answer
Last date for each user sql
SQL
0 vote205 views1 answer
SQL Where-Klausel
SQL
8 votes193 views6 answers
Sql insert
SQL
0 vote188 views2 answers
Compound operator in sql
SQL
6 votes172 views4 answers
How to remove unique key in mysql
SQL