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_at_dvfs.com <BLock_at_dvfs.com> 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
--
http://www.freelists.org/webpage/oracle-l
Received on Tue May 15 2007 - 11:13:51 CDT
