Re: Moving a table to another tablespace

From: Alistair Thomson <thomson_alistair_at_yahoo.co.uk>
Date: Wed, 4 Sep 2002 09:49:46 +0100
Message-ID: <al4hfd$1u9$1$830fa7b3@news.demon.co.uk>

If you export drop and reimport the table it will go straight back where it came from!.

Try export, drop, recreate the table in the new tablespace then import with the flag ignore =y

Alistair

"Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> wrote in message news:1031120115.839708_at_news.thyssen.com...
> Hello NG,
>
> by a mistake a table with a long raw collumn was createt in the wrong
> tablespace. How can I move this table (with content, of course) into the
> correct tablespace?
> I tried the alter table command but i always get the ORA-00997 Error. Any
> ideas?
>
> Thanx for you help!
>
>
> --
> ==================
> Lars Steinmetz
> ==================
>
>
Received on Wed Sep 04 2002 - 03:49:46 CDT