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 vote129 views1 answer
Lost connection to MySQL server during query when dumping table
SQL
0 vote90 views1 answer
Sql query with date
SQL
0 vote167 views2 answers
Suse Linux restart MySQL
SQL
34 votes165 views6 answers
Install mysql client ubuntu
SQL
2 votes130 views1 answer
Get first 2 letter in sql
SQL
0 vote146 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
0 vote146 views2 answers
Plsql function that return a table
SQL
1 vote131 views1 answer
Oracle split string
SQL
0 vote136 views1 answer
Low level operator in dbms
SQL
0 vote134 views1 answer
Opensuse status MySQL
SQL