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

3 votes173 views2 answers
Mysql HAVING
SQL
3 votes168 views1 answer
Postgres kill running query
SQL
2 votes162 views1 answer
Postgresql left join distinct on
SQL
1 vote208 views2 answers
Difference between in and between in sql
SQL
0 vote212 views1 answer
Ceil upto 2 decimal place mysql
SQL
1 vote189 views1 answer
Postgresql datetrunc too slow
SQL
0 vote179 views2 answers
Temp Space
SQL
0 vote205 views2 answers
Mysql show foreign keys
SQL
0 vote237 views1 answer
Selecting specific day in colum sql
SQL
37 votes383 views3 answers
Sql check duplicate value in column
SQL