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

2 votes111 views1 answer
Postgresql format date dd/mm/yyyy
SQL
0 vote112 views1 answer
Update All tables COLLATE DATABASE_DEFAULT
SQL
0 vote114 views1 answer
Sql include rows with 0 values
SQL
7 votes105 views4 answers
Database dump mysql command
SQL
0 vote99 views1 answer
Sql server manager close connection
SQL
0 vote116 views2 answers
How to get max from each department in sql
SQL
0 vote61 views1 answer
Get all stored procedures in sql server
SQL
0 vote131 views3 answers
Get count of null in column sql
SQL
1 vote94 views1 answer
Sql only five first row
SQL
0 vote111 views2 answers
Sql trigger difference between for and after
SQL