Index or partition of such index is in unusable state
尝试使用已标记为 UNUSABLE 的索引,通常在直接路径加载或分区操作后发生。
SELECT index_name, status FROM dba_indexes WHERE status = 'UNUSABLE';SELECT index_name, partition_name, status FROM dba_ind_partitions WHERE status = 'UNUSABLE';