Re: Move Table to another tablespace?

From: Richard Foote <richard.foote_at_bigpond.com>
Date: Mon, 10 Feb 2003 00:00:04 +1000
Message-ID: <O_r1a.44012$jM5.110996@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 - 08:00:04 CST