I do recall an Oracle 9.2.0.6 BUG (can't remember if it was platform specific to solaris or not), where an online rebuild of an index that was heavily used would cause ORA-600 errors (I had run into in our monitoring database a few years ago).
----- Original Message ----
From: dba1 mcc <mccdba1@yahoo.com>
To: oracle-l@freelists.org
Sent: Monday, October 22, 2007 2:55:22 PM
Subject: [Q] Online rebuild index danger or NOT???
We have ORACLE 10gr2 on Redhat server. Our
application vendor told me don't "online rebuild
index". They suggest kick out all users then rebuild
index.
I have been online rebuild index on several databases
since ORACLE 8.1.7 and NO problem.
I don't know why application vendor suggest don't
"online rebuild index". I like listen your
experience.
Thanks.
__________________________________________________
Do You Yahoo!?
Tired of spam? Yahoo! Mail has the best spam protection around
http://mail.yahoo.com
--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l
Received on Mon Oct 22 2007 - 16:31:42 CDT
