Re: [Q] Online rebuild index danger or NOT???

  • From: Bradd Piontek <piontekdd@xxxxxxxxx>
  • To: mccdba1@xxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Mon, 22 Oct 2007 14:31:42 -0700 (PDT)

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






Other related posts: