Re: Moving a table to another tablespace

From: Rafa³ Jank <yankee_at_wp.pl>
Date: Wed, 4 Sep 2002 09:46:37 +0200
Message-ID: <20020904094637.304c4843.yankee@wp.pl>

On Wed, 4 Sep 2002 08:19:52 +0200
"Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> wrote:

> 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?
>

Export, drop and reimport it.

-- 
_/        _/  _/_/_/  -----     Rafa³ Jank rjank_at_wp-sa.pl     -----
 _/  _/  _/  _/   _/         Wirtualna Polska SA   http://www.wp.pl 
  _/_/_/_/  _/_/_/    ul. Traugutta 115c, 80-237 Gdansk, tel/fax. (58)5215625
   _/  _/  _/         --------==*  http://szukaj.wp.pl *==----------

Received on Wed Sep 04 2002 - 02:46:37 CDT