It seams to me that there is an easier way:
ALTER TABLE table_name MOVE TABLESPACE new_tablespace_name;
HTH.
Regards,
Celine Armanet - Division ORACLE
EPICENTRE - 529 Route des Vernes 74370 PRINGY
Tel. : +33 04 50 09 7000
Fax : +33 04 50 66 92 19
E-Mail : carmanet_at_epicentre.fr
----------------------------------------------------------------------------
----
"Lars Steinmetz" <no_spam_lsteinmetz_at_jakrause.com> a écrit dans le 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 - 10:48:54 CDT
