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

1 vote346 views1 answer
Sql random sampling per group
SQL
0 vote336 views1 answer
VERIFY INDEXES WITH PARTITIONS IN SQL ORACLE
SQL
0 vote283 views1 answer
Sql server count all tables rows
SQL
0 vote296 views3 answers
Remove folders from remote git
SQL
7 votes292 views3 answers
Add primary key to database sql
SQL
4 votes286 views2 answers
Oracle default date format
SQL
4 votes276 views1 answer
Mysql set max connections
SQL
4 votes293 views1 answer
Wildcard in sql
SQL
1 vote305 views1 answer
Random name function in mysql for nvarchar
SQL
0 vote308 views2 answers
Dbms transaction tutorialspoint
SQL