Re: Alter index rebuild
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: BLock@xxxxxxxx
- Date: Wed, 16 May 2007 03:17:25 +1100
Sorry, mean DML.
On 5/16/07, Alexander Fatkulin <afatkulin@xxxxxxxxx> wrote:
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
--
Alexander Fatkulin
--
//www.freelists.org/webpage/oracle-l
Other related posts:
