RE: Move table online and update the indexes at the same time.

From: Pete Sharman <peter.sharman_at_oracle.com>
Date: Wed, 28 Jul 2004 00:07:05 +1000
Message-Id: <200407271407.i6RE75rS002003@rgmgw1.us.oracle.com>

Sorry didn't see your Huh message till after I saw this one, but anyway you=  got the picture. :)

 =

Pete
 =

"Controlling developers is like herding cats." Kevin Loney, Oracle DBA Handbook
 =

"Oh no, it's not. It's much harder than that!" Bruce Pihlamae, long-term Oracle DBA

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] = On Behalf Of Tanel P=F5der
Sent: Tuesday, 27 July 2004 7:34 PM
To: oracle-l_at_freelists.org
Subject: Re: Move table online and update the indexes at the same time.

> > BTW, in your earlier message you referred to ALTER TABLE MOVE. That's
for
> =3D
> > IOT's only and wouldn't help anyway.
>
> Huh?

Ok, now I get it, alter table move online works for IOTs (although in background it just re-creates the IOT into new tablespace, keeping a journa= l
table for intermediate updates..)

Tanel.

---

Please see the official ORACLE-L FAQ: http://www.orafaq.com

---

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.

--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------


----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Tue Jul 27 2004 - 09:13:07 CDT