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

From: Falco Paul <falco_at_palm.nl>
Date: Thu, 18 Jan 2001 12:56:16 +0100
Message-ID: <946lqh$m20$1@azure.nl.gxn.net>

I believe this only works for IOT's.
Heap tables don't move at all with this command (at least not in 8.1.6, didn't test 8.1.7 yet).
I heard Oracle 9 should support a 'true'ALTER TABLE REBUILD (storage specs) command.

Falco

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> schreef in bericht news:t6c6pddh43757f_at_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 Thu Jan 18 2001 - 05:56:16 CST