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 vote25 views1 answer
Faire une recherche par liste de mot clé sql
SQL
3 votes35 views1 answer
Increment integer in table sql
SQL
14 votes29 views1 answer
Excel is not a database
SQL
6 votes41 views2 answers
Install psql mac
SQL
4 votes31 views1 answer
What are the data types in sql
SQL
0 vote38 views1 answer
ValueError: A string literal cannot contain NUL (0x00) characters.
SQL
3 votes32 views1 answer
Ssh check mysql version
SQL
0 vote28 views1 answer
Mysql select field if condition
SQL
0 vote29 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote37 views1 answer
Get employees if not contains in sql
SQL