Re: Alter index rebuild

From: Bradd Piontek <piontekdd_at_yahoo.com>
Date: Tue, 15 May 2007 09:30:50 -0700 (PDT)
Message-ID: <993977.13073.qm@web80603.mail.mud.yahoo.com>

Be sure to test, however, the way you have it, the index will be lock DML. You may want to look at the online aspect of the rebuild operation. I have run into several bugs in oracle that cause issues with online index rebuilds, however.

Original Message ---- From: "BLock_at_dvfs.com" <BLock_at_dvfs.com> To: oracle-l_at_freelists.org Sent: Tuesday, May 15, 2007 10:52:23 AM Subject: Alter index rebuild

Can I do an Alter Index rebuild to move
an index to an index tablespace while the database is up?

We are a 24x7 operation with scheduled
outages usually only once a month.

alter index schema.I_B_OAPREFSETTLEMENTVALUE_1 rebuild tablespace schema_IDX storage ( initial 256 K next 256 K pctincrease 0 ) ;

Thanks

Brian Lock

DBA - East Campus

--

http://www.freelists.org/webpage/oracle-l Received on Tue May 15 2007 - 11:30:50 CDT