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 vote277 views1 answer
Postgresql export output table as a csv
SQL
5 votes275 views1 answer
Oracle list functions
SQL
0 vote269 views2 answers
Select index table oracle
SQL
0 vote274 views1 answer
How to add boolean column in postgresql
SQL
9 votes297 views3 answers
Where clause sql
SQL
1 vote265 views1 answer
Oracle sql average
SQL
7 votes255 views1 answer
Forge server hosting
SQL
2 votes228 views1 answer
Mysql admin u root p password change password
SQL
0 vote263 views2 answers
Postgresql get last day of month
SQL
-1 vote261 views1 answer
How to open blade file from blade in laravel
SQL