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 vote59 views1 answer
Sql truncate table referencing itself
SQL
0 vote109 views1 answer
Sqlite get date only
SQL
1 vote102 views1 answer
Check message id sql server
SQL
0 vote109 views1 answer
Trigger vérifier stock
SQL
1 vote94 views1 answer
Copy postgres table from one schema into another
SQL
0 vote103 views1 answer
Postgresql select join by date - Join rows where a timestamp value is equal to midnight of the date
SQL
0 vote161 views1 answer
How to rename a database in tsql
SQL
-1 vote102 views1 answer
Sql oracle take only last results
SQL
0 vote94 views1 answer
Sql comparison operators
SQL
7 votes102 views2 answers
Oracle foreign key reference table
SQL