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 <Jacques.Kilchoer_at_quest.com>
wrote: > > -----Original Message-----
> > From: cjordan_at_smcwv.com [mailto:cjordan_at_smcwv.com]
> >
> > 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: hamcdc_at_yahoo.co.uk
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: ListGuru_at_fatcity.com (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).
Received on Tue Oct 23 2001 - 03:39:12 CDT