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 vote188 views1 answer
Codigo crear tablas sql server
SQL
16 votes217 views1 answer
Sqlserver add column to table
SQL
1 vote169 views1 answer
Oracle sql create or replace view
SQL
0 vote199 views1 answer
Run sql script file and changes db name in this file using c#
SQL
0 vote211 views1 answer
Bitmap join index
SQL
-1 vote196 views1 answer
Auto increment psql not primary key
SQL
2 votes178 views2 answers
Mysql limit
SQL
0 vote183 views1 answer
Mysql multiple count
SQL
1 vote199 views1 answer
Mysql datetime with timezone offset
SQL
5 votes184 views2 answers
Sql create tabel with primary key auto_increment code
SQL