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

10 votes112 views4 answers
Primary key sql
SQL
0 vote124 views1 answer
Postgresql inline table
SQL
5 votes117 views1 answer
Commentaire table oracle
SQL
0 vote115 views1 answer
Laravel eloquent get generated sql
SQL
0 vote109 views1 answer
Sql server get date of previous sunday
SQL
1 vote119 views1 answer
How to print longest name in sql
SQL
0 vote133 views1 answer
Mssql find deadlocks
SQL
5 votes104 views1 answer
List foreign key oracle
SQL
4 votes101 views1 answer
Oracle session date format
SQL
12 votes105 views4 answers
How to take database dump in postgresql
SQL