RE: Alter index rebuild
- From: "Kerber, Andrew W." <Andrew.Kerber@xxxxxxx>
- To: afatkulin@xxxxxxxxx, BLock@xxxxxxxx
- Date: Tue, 15 May 2007 11:43:56 -0500
You have to watch it with rebuild online, as I recall there is a bug in
versions prior to 10g that will generate ora-600 errors during a rebuild
online if users try to access it during the rebuild.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alexander Fatkulin
Sent: Tuesday, May 15, 2007 11:17 AM
To: BLock@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Alter index rebuild
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
------------------------------------------------------------------------------
NOTICE: This electronic mail message and any attached files are confidential.
The information is exclusively for the use of the individual or entity intended
as the recipient. If you are not the intended recipient, any use, copying,
printing, reviewing, retention, disclosure, distribution or forwarding of the
message or any attached file is not authorized and is strictly prohibited. If
you have received this electronic mail message in error, please advise the
sender by reply electronic mail immediately and permanently delete the original
transmission, any attachments and any copies of this message from your computer
system. Thank you.
==============================================================================
--
//www.freelists.org/webpage/oracle-l
Other related posts:
