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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] = On Behalf Of Tanel P=F5der Sent: Tuesday, 27 July 2004 7:34 PM To: oracle-l@xxxxxxxxxxxxx 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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //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@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------