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

Cool, must have done something stupid!
Falco

<robertgfreeman_at_my-deja.com> schreef in bericht news:946v5l$5lj$1_at_nnrp1.deja.com...
> ALTER TABLE MOVE works fine in 8.1.6 for heap tables.
>
> Robert
>
> In article <946lqh$m20$1_at_azure.nl.gxn.net>,
> "Falco Paul" <falco_at_palm.nl> wrote:
> > 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)
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > >
> > >
> >
> >
>
>
> Sent via Deja.com
> http://www.deja.com/
Received on Thu Jan 18 2001 - 09:19:18 CST