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 vote106 views1 answer
Mysql update sum same table
SQL
0 vote68 views1 answer
Mysql workbench search all tables
SQL
5 votes147 views2 answers
Functions
SQL
22 votes107 views6 answers
Create sql table
SQL
0 vote135 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote119 views1 answer
Oracle table privileges
SQL
1 vote121 views2 answers
Datetrunc hour snowflake
SQL
2 votes110 views1 answer
Postgresql add entry to table
SQL
1 vote107 views1 answer
Oracle explain plan
SQL
4 votes119 views3 answers
Drop Table Oracle
SQL