Re: Alter index rebuild
- From: "Sandra Becker" <sbecker6925@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Tue, 15 May 2007 13:15:46 -0600
Just one more caveat--if you are using Standard One Edition, regardless of
the version, you cannot rebuild an index online. Been there, tried that.
Sandy
On 5/15/07, Syed Jaffar Hussain <sjaffarhussain@xxxxxxxxx> wrote:
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 the
index rebuild to update the new index later
Jaffar
On 5/15/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
>
>
--
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."
Other related posts:
