RE: Alter index rebuild

  • From: "Baumgartel, Paul" <paul.baumgartel@xxxxxxxxxxxxxxxxx>
  • To: "'BLock@xxxxxxxx'" <BLock@xxxxxxxx>, oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 15 May 2007 12:31:04 -0400

Yes.  And if you are on at least Oracle9i, you can add the "online" keyword to 
allow DML on the indexed table during the rebuild.

Paul Baumgartel 
Information Technology 
Securities Processing Databases Americas 
One Madison Avenue 
New York, NY 10010 
Phone 212.538.1143 



From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On 
Behalf Of BLock@xxxxxxxx
Sent: Tuesday, May 15, 2007 11:52 AM
To: oracle-l@xxxxxxxxxxxxx
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 ) ; 


Brian Lock
DBA - East Campus

Please access the attached hyperlink for an important electronic communications 

Other related posts: