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.
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/10173379/viewspace-617787/ ，如需转载，请注明出处，否则将追究法律责任。
