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

27 votes241 views5 answers
Mysql set password for user
SQL
0 vote235 views1 answer
Sql insert from excel
SQL
3 votes312 views1 answer
Oracle show trigger code
SQL
0 vote194 views1 answer
Não é possível executar uma operação DML dentro de uma consulta
SQL
14 votes250 views3 answers
Inner join sql oracle
SQL
0 vote187 views2 answers
Django.db.utils.OperationalError: (1698, "Access denied for user 'root'@'localhost'")
SQL
3 votes205 views1 answer
Oracle drop user
SQL
0 vote248 views1 answer
How to print some string in mysql
SQL
0 vote190 views1 answer
Incorrect datetime value sql table error 1292
SQL
5 votes241 views1 answer
Get column name sql server
SQL