You need Enterprise Edition. Using 817 SE you will get a nice error:
SQL> alter table uwi_mjf
2 move online tablespace atcorwork;
alter table uwi_mjf
*
ERROR at line 1:
ORA-00439: feature not enabled: Online Index Build
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
news:v45m1rdm8pambc_at_corp.supernews.com...
>
> "Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> wrote in message
> news:b1uihe$17l65v$1_at_ID-97972.news.dfncis.de...
> > Hello NG,
> >
> > how can I move a table with it's data move to another tablespace? Is
there
> > an "alter table move" command?
> > May someone help me?
> >
> > Thanx
> >
> > Greets Lars
> >
> >
>
> There is in 8i and higher
> alter table ... move tablespace ...
> Note: this command doesn't work for tables with a LONG column.
>
> Hth
>
>
> --
> Sybrand Bakker
> Senior Oracle DBA
>
> to reply remove '-verwijderdit' from my e-mail address
>
>
Received on Fri Feb 07 2003 - 09:55:03 CST
