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

Home -> Community -> Mailing Lists -> Oracle-L -> Alter index rebuild

Alter index rebuild

From: <BLock_at_dvfs.com>
Date: Tue, 15 May 2007 11:52:23 -0400
Message-ID: <OF63B8811D.C24A09F6-ON852572DC.0056B659-852572DC.00572FE4@allianzlife.com>


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 - 10:52:23 CDT

Original text of this message

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