- ora-29861:域索引标记为loading/failed/unusable
select owner,index_name from all_indexes where domidx_status != 'VALID' or domidx_opstatus !='VALID';
drop index CONTRACTLINE_NDX2;
select owner,index_name from all_indexes where domidx_status != 'VALID' or domidx_opstatus !='VALID';
drop index CONTRACTLINE_NDX2;
转载于:https://www.cnblogs.com/leeyq/archive/2012/08/19/2646883.html