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 vote229 views1 answer
Sql server python connection
SQL
1 vote320 views1 answer
Aqua Data studio postgresql ssl
SQL
6 votes241 views2 answers
How to copy data in sql
SQL
0 vote256 views1 answer
Sql quary intervewi question
SQL
0 vote248 views1 answer
Mysql query to select the highest value
SQL
-1 vote250 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
0 vote236 views1 answer
Recover deleted data from mysql database
SQL
1 vote229 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
16 votes235 views1 answer
Sql comment'
SQL
2 votes262 views2 answers
Sql lag
SQL