object所在的datafile offline后, status 仍然是usable

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.

请使用浏览器的分享功能分享到微信等