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 vote357 views1 answer
Events not working db
SQL
4 votes361 views1 answer
Sql quote in string
SQL
0 vote335 views1 answer
Format the money fied with comma in international system using sql
SQL
23 votes406 views5 answers
Sql substring
SQL
0 vote408 views1 answer
Mysql create index lost connection
SQL
32 votes365 views6 answers
Insert into values select
SQL
0 vote382 views1 answer
How do I insert a blob in SQL?
SQL
1 vote397 views1 answer
Sql server if exists update else insert
SQL
0 vote383 views1 answer
Oracle locked objects
SQL
0 vote363 views1 answer
Day of the week sqlite
SQL