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 vote201 views1 answer
Mysql connection with sqlalchecmy
SQL
5 votes219 views1 answer
Sql check if date is between 2 dates
SQL
1 vote216 views1 answer
Import mysql dump database command line linux
SQL
0 vote204 views10 answers
John the ripper mysql
SQL
0 vote215 views1 answer
Add alternate add column sql
SQL
5 votes203 views1 answer
Mysql get last day of month
SQL
13 votes223 views2 answers
Oracle select into and inner join
SQL
0 vote222 views1 answer
Sql alter table order by
SQL
1 vote222 views1 answer
Mysql copy table1 to table2
SQL
3 votes234 views1 answer
APEX elapsed time
SQL