Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Alter index rebuild
Which version of Oracle are you using?
You can rebuild the index using online so that it will not affect the end-users during rebuilding process.
However, one thing you need to be care is about the space. Rebuild requires almost double space during index rebuilding process and also generates lot of redo and which can leads to good amount of archived logs. All these depends on the size of the index.
An index rebuilt either Online or Offline.
Online Index Rebuild Features:
+ ALTER INDEX REBUILD ONLINE; + DMLs are allowed on the base table + It is comparatively Slow + Base table is referred for the new index + Base table is locked in shared mode and DDLs are not possible + Intermediate table stores the data changes in the base table, during theindex rebuild to update the new index later
Jaffar
On 5/15/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
>
>
-- Best Regards, Syed Jaffar Hussain Oracle ACE 8i,9i & 10g OCP DBA http://jaffardba.blogspot.com/ http://www.oracle.com/technology/community/oracle_ace/ace1.html#hussain ---------------------------------------------------------------------------------- "Winners don't do different things. They do things differently." -- http://www.freelists.org/webpage/oracle-lReceived on Tue May 15 2007 - 11:57:04 CDT
![]() |
![]() |