ONLINE_INDEX_CLEAN
If ORA-08104 error (ORA-08104: this index object < -- > is being online built or rebuilt) seen please run the below procedure
declare
isclean boolean;
begin
isclean := false;
while isclean = false
loop
isclean := DBMS_REPAIR.ONLINE_INDEX_CLEAN
(dbms_repair.all_index_id, dbms_repair.lock_wait);
dbms_lock.sleep (10);
end loop;
end;
/
If ORA-08104 error (ORA-08104: this index object < -- > is being online built or rebuilt) seen please run the below procedure
declare
isclean boolean;
begin
isclean := false;
while isclean = false
loop
isclean := DBMS_REPAIR.ONLINE_INDEX_CLEAN
(dbms_repair.all_index_id, dbms_repair.lock_wait);
dbms_lock.sleep (10);
end loop;
end;
/
No comments