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

5 votes123 views2 answers
Oracle to_timestamp
SQL
1 vote154 views1 answer
Sql server read uncommitted
SQL
7 votes122 views6 answers
Reset identity column in sql server
SQL
10 votes128 views5 answers
Create table mysql query
SQL
9 votes126 views2 answers
Mysql change value
SQL
0 vote129 views1 answer
Sql cursor example multiple columns
SQL
4 votes150 views1 answer
Alter session set nls_date_format
SQL
1 vote121 views1 answer
Delete triger pl pg sql
SQL
2 votes169 views6 answers
In operator in sql
SQL
0 vote118 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL