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@xxxxxxxxx> To: oracle-l@xxxxxxxxxxxxx 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 -- //www.freelists.org/webpage/oracle-l