ALL_TAB_SUBPARTITIONS

obclient [SYS]> SELECT TABLE_OWNER, TABLE_NAME, PARTITION_NAME, SUBPARTITION_NAME, HIGH_VALUE, HIGH_VALUE_LENGTH, PARTITION_POSITION, SUBPARTITION_POSITION
   FROM SYS.ALL_TAB_SUBPARTITIONS
   WHERE TABLE_NAME='TBL2_F_RL';

+-------------+------------+----------------+-------------------+------------+-------------------+--------------------+-----------------------+
| TABLE_OWNER | TABLE_NAME | PARTITION_NAME | SUBPARTITION_NAME | HIGH_VALUE | HIGH_VALUE_LENGTH | PARTITION_POSITION | SUBPARTITION_POSITION |
+-------------+------------+----------------+-------------------+------------+-------------------+--------------------+-----------------------+
| SYS         | TBL2_F_RL  | P0             | SP0               | 1,3        |                 3 |                  1 |                     1 |
| SYS         | TBL2_F_RL  | P0             | SP1               | 4,6        |                 3 |                  1 |                     2 |
| SYS         | TBL2_F_RL  | P0             | SP2               | 7,9        |                 3 |                  1 |                     3 |
| SYS         | TBL2_F_RL  | P1             | SP3               | 1,3        |                 3 |                  2 |                     1 |
| SYS         | TBL2_F_RL  | P1             | SP4               | 4,6        |                 3 |                  2 |                     2 |
| SYS         | TBL2_F_RL  | P1             | SP5               | 7,9        |                 3 |                  2 |                     3 |
+-------------+------------+----------------+-------------------+------------+-------------------+--------------------+-----------------------+
6 rows in set