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

Query DBA_TAB_SUBPARTITIONS

 
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>