Jacques i think oracle puts exclusive locks on the table on which you are trying to create an index. that reason should be good enough to use the "rebuild online" option instead of create/drop especially for systems that require to be available all the time
Deepak --- Jacques Kilchoer <[EMAIL PROTECTED]> wrote: > > -----Original Message----- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] > > > > What are the advantages/disadvantages to doing a > alter index rebuild > > (Oracle 8.0.X) versus dropping and recreating the > index. > > > My personal opinion - if your database is not > subject to any of the bugs > reported against alter index ... rebuild commands, > {some bug examples: > [BUG:1475310] ALTER INDEX .. REBUILD ONLINE/ MOVE > IOT ONLINE can corrupt the > index. See [NOTE:125149.1] > [BUG:1427002] ALTER INDEX i REBUILD > PARAMETERS('SYNC') may raise ORA-29863 / > DRG-10595 / ORA-28579 (interMedia Text) > [BUG:1573283] OERI:6033 from ALTER INDEX .. REBUILD > ONLINE PARAMETERS > ('OPTIMIZE FULL') > etc... > } > > alter index ... rebuild is easier to use, since you > don't have to specify > the full syntax that was used to build the index. I > don't know of any > reasons to prefer the drop index / create index > method. > > Any corrections/suggestions welcome. > __________________________________________________ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
