Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: alter index rebuild (NOT ONLINE)

Re: alter index rebuild (NOT ONLINE)

From: Howard J. Rogers <hjr_at_dizwell.com>
Date: Thu, 30 Oct 2003 06:32:27 +1100
Message-ID: <3fa01553$0$2239$afc38c87@news.optusnet.com.au>

<OakRogbak_erPine_at_yahoo.com> wrote in message news:13fdc9b4.0310290852.145fddf7_at_posting.google.com...
> What is the consequence of doing an ALTER INDEX IDXNAME REBUILD
> TABLESPACE INDX2;
> in an Oracle 8.1.7.0.0 database if that table is be used (possible
> DML)? Would an update statement fail or hang until the index is
> finished moving and rebuilding?
>
> I don't want to do the ONLINE rebuild until I patch my db due to the
> 1475310 bug?
>
> Thanks!

\ Received on Wed Oct 29 2003 - 13:32:27 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US