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 -> Re: alter table move... What Oracle version?

Re: alter table move... What Oracle version?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Wed, 17 Jan 2001 23:10:14 +0100
Message-ID: <t6c6pddh43757f@beta-news.demon.nl>

8.1 aka 8i only.

Hth,

Sybrand Bakker, Oracle DBA

"Syltrem" <syltrem_at_videotron.ca> wrote in message news:Wmo96.7224$hP5.247921_at_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 - 16:10:14 CST

Original text of this message

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