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 vote277 views1 answer
Install sql server in ubuntu 20.04
SQL
-2 votes275 views1 answer
Use of where in left join in mysql
SQL
1 vote299 views1 answer
How to get the date diff on once field in sql server
SQL
0 vote300 views1 answer
Doesn't have default value mysql
SQL
0 vote270 views1 answer
Sql query for displaying age from oldest to youngest
SQL
2 votes305 views1 answer
Get the mysql table columns data type mysql
SQL
0 vote308 views1 answer
Comparing with today and yesterday record in sql query
SQL
0 vote280 views1 answer
Mysql subtract month from timestamp
SQL
11 votes302 views2 answers
Oracle saurce code
SQL
25 votes280 views6 answers
Sql update query
SQL