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 vote193 views1 answer
Mysql set boolean default value
SQL
2 votes197 views1 answer
Guid to string sql
SQL
1 vote231 views2 answers
Difference between in and between in sql
SQL
0 vote266 views1 answer
<sql:datasource var="Snapsho"
SQL
0 vote219 views1 answer
Count number of entires by months sql
SQL
1 vote177 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
1 vote192 views1 answer
Sql week commencing date
SQL
0 vote188 views1 answer
Sql cursor example multiple columns
SQL
0 vote175 views1 answer
Sql server bool select
SQL
0 vote150 views1 answer
Count char in java
SQL