Oracle PL/SQL/System Tables Views/DBA TAB SUBPARTITIONS

Query DBA_TAB_SUBPARTITIONS

   <source lang="sql">

SQL> SQL> SQL> COLUMN TABLESPACE_NAME FORMAT A20 SQL> COLUMN PARTITION_NAME FORMAT A20 SQL> COLUMN SUBPARTITIONE_NAME FORMAT A20 SQL> SELECT TABLESPACE_NAME

 2      , PARTITION_NAME
 3      , SUBPARTITION_NAME
 4  FROM DBA_TAB_SUBPARTITIONS WHERE TABLE_NAME="ORDER_TAB"
 5  ORDER BY SUBPARTITION_NAME;

no rows selected SQL>

 </source>