I agree. If you're really tight on space, you may need to consider drop/create, otherwise rebuilds generally are the way to go.
hth connor --- 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. > ===== Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" ____________________________________________________________ Nokia Game is on again. Go to http://uk.yahoo.com/nokiagame/ and join the new all media adventure before November 3rd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).