Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> alter table move... What Oracle version?

alter table move... What Oracle version?

From: Syltrem <syltrem_at_videotron.ca>
Date: Wed, 17 Jan 2001 16:46:32 -0500
Message-ID: <Wmo96.7224$hP5.247921@wagner.videotron.net>

I think there is a new command to move tables between tablespaces in Oracle 8, but is it available on 805 or only starting with 810?

And would this be the correct syntax?
ALTER TABLE XX MOVE TABLESPACE ZZ STORAGE (INITIAL nn);

Thanks!

--
Syltrem
http://pages.infinit.net/syltrem (OpenVMS Web Site)
Received on Wed Jan 17 2001 - 15:46:32 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US