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

Yet another example of posting utterly wrong disinformation to total newbies. I really wish people would *test* this stuff before posting. And test it on boring old EMP, which at least has the advantage of being a perfectly normal table accessible to all.

To post this and *then* discover that your test table actually doesn't exist at all except as some logical construct within a cluster is simply to confuse people who don't deserve to be.

If you (or anyone else) purports to proffer solutions, one might reasonably expect the "solutions" to have gone through the minimum of testing.

What makes this case particularly egregious is that the Oracle documentation on the subject is utterly un-ambiguous, and all and any Oracle Press books would have given the correct answer in a matter of minutes.

HJR "Falco Paul" <falco_at_palm.nl> wrote in message news:9471n8$peb$1_at_azure.nl.gxn.net...
> 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 Fri Jan 19 2001 - 06:58:55 CST