RE: Alter index rebuild

From: Baumgartel, Paul <paul.baumgartel_at_credit-suisse.com>
Date: Tue, 15 May 2007 12:31:04 -0400
Message-ID: <D97D1FAE0521BD44820B920EDAB3BBAC1663C335@ENYC11P32005.corpny.csfb.com>

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
CREDIT SUISSE
Information Technology
Securities Processing Databases Americas One Madison Avenue
New York, NY 10010
USA
Phone 212.538.1143
paul.baumgartel_at_credit-suisse.com
www.credit-suisse.com  

---

From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of BLock_at_dvfs.com Sent: Tuesday, May 15, 2007 11:52 AM
To: oracle-l_at_freelists.org
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

---

Please access the attached hyperlink for an important electronic communications disclaimer:

http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html

---

--
http://www.freelists.org/webpage/oracle-l

Received on Tue May 15 2007 - 11:31:04 CDT