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 vote355 views1 answer
Combine 2 columns search query mysql
SQL
0 vote317 views1 answer
Mysql filter based on datediff
SQL
0 vote346 views2 answers
Amazon linux postgresql client
SQL
15 votes323 views1 answer
Mysql int range
SQL
0 vote305 views1 answer
Sql inserted
SQL
0 vote341 views1 answer
Command to give readonly access to a postgres sql user
SQL
0 vote332 views1 answer
Show the colums of table sql
SQL
2 votes262 views1 answer
Sql group by different columns
SQL
1 vote323 views1 answer
Md5 encryption for existing records
SQL
0 vote338 views2 answers
How to prevent sql injection in java
SQL