Re: Alter index rebuild
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: BLock@xxxxxxxx
- Date: Wed, 16 May 2007 03:13:51 +1100
Sure, you can also try an "online" option - that way you can still
perform DDL against the table while index is being rebuild.
On 5/16/07, BLock@xxxxxxxx <BLock@xxxxxxxx> wrote:
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
--
Alexander Fatkulin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
