I'm not following. Isn't this the command to move a table to a different
tablespace?
In my example, table uwi_mjf is a simple table with no indexes or
primary/unique constraints.
--
Terry Dykstra
Canadian Forest Oil Ltd.
"Richard Foote" <richard.foote_at_bigpond.com> wrote in message
news:O_r1a.44012$jM5.110996_at_newsfeeds.bigpond.com...
> "Terry Dykstra" <dontreply_tddykstra_at_forestoil.ca> wrote in message
> news:rFQ0a.127207$Ui4.4196165_at_news1.telusplanet.net...
> > 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
> >
> > --
>
> Hi Terry,
>
> The OP and Sybrand were talking in relation to moving a *table* to another
> tablespace.
>
> Your example nicely shows you can not recreate an *index* online, without
> EE, which is hardly the same thing. Admittedly an index organised table is
> close but it's the index online feature that is being violated here.
>
> Cheers
>
> Richard
>
>
>
>
Received on Sun Feb 09 2003 - 22:13:46 CST
