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 vote187 views1 answer
Oracle index hint
SQL
1 vote180 views1 answer
Oracle sql create or replace view
SQL
4 votes194 views2 answers
Mysql select where starts with
SQL
0 vote202 views1 answer
"SET SQL_AUTO_IS_NULL = 0" query problem
SQL
0 vote195 views1 answer
Learn sqlite dart
SQL
0 vote179 views1 answer
Full syntax inner join
SQL
0 vote207 views1 answer
Creating a simple notify in postgresql
SQL
0 vote194 views1 answer
Sqlalchemy sequence postgresql
SQL
0 vote183 views1 answer
Fetch second word from a string in ms sql
SQL
11 votes209 views3 answers
Sql_mode=only_full_group_by
SQL