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 vote283 views1 answer
Sql query for getting data with join and count
SQL
0 vote374 views2 answers
SQL SERVER ORDER BY DATE NULL LAST
SQL
0 vote304 views1 answer
Add multiple field in table sql
SQL
1 vote286 views1 answer
Oracle start job
SQL
3 votes318 views1 answer
Unsigned int in mysql
SQL
1 vote312 views1 answer
Sql server epoch to datetime
SQL
0 vote308 views1 answer
With_for_update sqlalchemy
SQL
5 votes280 views1 answer
List foreign key oracle
SQL
0 vote292 views1 answer
Sql select min row
SQL
2 votes315 views2 answers
Storing timezones in postgres
SQL