SQL> select index_name, partition_name, status from dba_ind_partitions
2 where index_name = 'IDX_ACCOUNTUNLOCKEX_ORDERID';
INDEX_NAME PARTITION_NAME STATUS
------------------------------ ------------------------------ --------
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_10B USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_10A USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_09B USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_09C USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_10C USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_11A USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_11B USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_11C USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_12A USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_12B USABLE
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_2009_12C USABLE
INDEX_NAME PARTITION_NAME STATUS
------------------------------ ------------------------------ --------
IDX_ACCOUNTUNLOCKEX_ORDERID CDRTIME_MAXVALUE USABLE
12 rows selected.