RE: Alter index rebuild
- From: "Sweetser, Joe" <JSweetser@xxxxxxxx>
- To: <afatkulin@xxxxxxxxx>, <BLock@xxxxxxxx>
- Date: Tue, 15 May 2007 10:30:23 -0600
The online option appears to be an Enterprise Edition feature/option.
Here's the result from a 10.2.0.2 standard edition attempt on RH Linux.
-joe
SQL> alter index THUNDERHEAD.PK_CM_ANNOTATIONS rebuild tablespace
thead_i online;
alter index THUNDERHEAD.PK_CM_ANNOTATIONS rebuild tablespace thead_i
online
*
ERROR at line 1:
ORA-00439: feature not enabled: Online Index Build
SQL>
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Alexander Fatkulin
Sent: Tuesday, May 15, 2007 10:14 AM
To: BLock@xxxxxxxx
Cc: oracle-l@xxxxxxxxxxxxx
Subject: Re: Alter index rebuild
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
--
//www.freelists.org/webpage/oracle-l
Confidentiality Note: This message contains information that may be
confidential and/or privileged. If you are not the intended recipient, you
should not use, copy, disclose, distribute or take any action based on this
message. If you have received this message in error, please advise the sender
immediately by reply email and delete this message. Although ICAT Managers, LLC
scans e-mail and attachments for viruses, it does not guarantee that either are
virus-free and accepts no liability for any damage sustained as a result of
viruses. Thank you.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
