SQL> declareisclean boolean;beginisclean := false;while isclean = falseloopisclean := DBMS_REPAIR.ONLINE_INDEX_CLEAN (dbms_repair.all_index_id, dbms_repair.lock_wait);dbms_lock.sleep (10);end loop;end;/PL/SQL procedure successfully completed.
SQL> alter index SCOTT.DAILY_JOB_IX1 rebuild online;Index altered.Metalink Ref docs –
NOTE:1324941.1 – How To Find Out Temporary Table Sys_journal_xxxxx Is Created By Rebuilding Which IndexNOTE:1378173.1 – How to use DBMS_REPAIR.ONLINE_INDEX_CLEAN ?NOTE:247487.1 – Rebuilding Index Online Gives ORA-8106