While rebuilding index my toad session was hanged and I decided to kill session but it also hanged
To fix it I connected db with new sesssion and got object_id of mentioned index
--Note flags
Using DBMS_REPAIR package clean index
--Note flags
As you see it was decreased and normal
SQL> alter index xxx.xxxxx rebuild online parallel 8;To fix it I connected db with new sesssion and got object_id of mentioned index
 SQL> select object_id obj#, i.status from dba_indexes i, dba_objects o  
 where o.object_name=i.index_name and  
 i.index_name='LOYAL_RES_IDX1';--Note flags
SQL> select flags from ind$ where obj#=356001; Using DBMS_REPAIR package clean index
SQL> 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;  
 /  --Note flags
 SQL> select flags from ind$ where obj#=356001; As you see it was decreased and normal
 
 
Superb Blog. I really enjoyed very much with this article here. Really its a amazing article i had ever read. I hope it will help a lot for all. Thank you so much for this amazing posts and please keep update like this excellent article.thank you for sharing such a great blog with us. expecting for your updation.
ReplyDeleteOracle Training Institute in chennai