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

7 votes156 views1 answer
Oracle reset sequence
SQL
0 vote180 views2 answers
Suse Linux restart MySQL
SQL
0 vote174 views1 answer
Set classpath for mysql-connector.jar
SQL
4 votes144 views4 answers
Print pl sql
SQL
0 vote165 views1 answer
The fetch keyword oracle
SQL
1 vote144 views2 answers
Sql server add time to date
SQL
0 vote140 views1 answer
Add colum date in sql
SQL
0 vote154 views1 answer
Which sql statement would you use to remove a view called emp_dept_vu from your schema?
SQL
0 vote155 views1 answer
Soql user profile
SQL
0 vote163 views1 answer
Python connect to mysql in settings.py
SQL