Re: Moving a table to another tablespace

From: Mark D Powell <mark.powell_at_eds.com>
Date: 4 Sep 2002 06:02:29 -0700
Message-ID: <178d2795.0209040502.7161f560@posting.google.com>

"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!

Try using exp to save the data; then drop and recreate the table in the new tablespace; run imp with ignore=y option to bring back the data

HTH -- Mark D Powell -- Received on Wed Sep 04 2002 - 08:02:29 CDT