Kalo di 10gR2 ada dbms_repair.online_index_clean utk bersih2 apabila online rebuild gagal.
Kalau di versi sebelumnya, sepertinya mesti kontak support oracle deh.. Ini ada contoh solusi dari http://www.experts-exchange.com/Databases/Oracle/Product_Info/Q_21127791.html: ------------------------------------------ You can either wait for the current operation to complete - V$session_longops may give some details of progress, or drop the index with "drop index <idxname> force;" and recreate it. Heres a note I found from Oracle, but I wouldnt do this myself without checking with Oracle support first. Goal The client and shadow process that were performing a ALTER INDEX REBUILD ONLINE were killed. (kill -9) . Attempts to drop the index returned ORA-8104 This index object %s is being online built or rebuilt. Fix The killed process that was performing the ALTER INDEX REBUILD ONLINE left the REBUILD FLAG (bit 512) in the IND$ table. This statement will show all of the indexes that are in the REBUILD ONLINE mode Select obj# from ind$ where bitand(flags, 512)=512; To fix the problem: ============== Update ind$ set flags=flags-512 where obj#={object ID of the problem index}; commit; Verify that the change was done: ======================== Select flags from ind$ where obj#={object ID of the problem index}; Now should be able to drop the index: =========================== drop index {index name}; drop the SYS_JOURNAL_{obj ID} If you still get an error on the drop, try: ============================ update ind$ set flags=0 where obj#={object ID of the problem index}; commit; shutdown abort startup ----------------------------------------- regards, tomi --- AJ <[EMAIL PROTECTED]> wrote: > saya ada membuat index, sewaktu dijalankan karena > lama sekali > akhirnya database saya restart. > Setelah database dinaikkan, saya ulangi lagi membuat > indexnya tetapi > muncul pesan error sbb: > > SQL> create index syscre_idx ON recharges > (sys_creation_date) > tablespace RPMIX nologging parallel 10 > > ERROR at line 1: > ORA-00955: name is already used by an existing > object > > dicoba untuk drop indexnya, muncul error : > SQL> drop index syscre_idx; > drop index syscre_idx > > ERROR at line 1: > ORA-08104: this index object 562559 is being online > built or rebuilt > > ada yg tahu harus dilakukan apa > > trims __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com -- -----------I.N.D.O - O.R.A.C.L.E--------------- Keluar: [EMAIL PROTECTED] Website: http://indo-oracle.blogspot.com Mirror: http://indooracle.wordpress.com ----------------------------------------------- Bergabung dengan Indonesia Thin Client User Groups, Terminal Server, Citrix, New Moon Caneveral, di: http://indo-thin.blogspot.com Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/indo-oracle/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/indo-oracle/join (Yahoo! ID required) <*> To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
