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;