RE: Rebuilding Indexes Question

From: Deepak Thapliyal <deepakthapliyal_at_yahoo.com>
Date: Mon, 22 Oct 2001 17:48:11 -0700
Message-ID: <F001.003B1CA6.20011022171517@fatcity.com>

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 <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.
  >
  

  ---

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: deepakthapliyal_at_yahoo.com

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 Mon Oct 22 2001 - 19:48:11 CDT