| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Need to move a table with a long
well, it's a pain in the behind, but you can export the table, drop the
original, create the table (empty) in the new tablespace and import with
ignore=Y to ignore the creation error.
Don't know of any other way, you can't do COPY in SQL*Plus 'cause you want to keep the same owner.
>From: Scott Canaan <srcdco_at_ritvax.isc.rit.edu>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Need to move a table with a long
>Date: Mon, 18 Dec 2000 11:30:42 -0800
>
> I need to move a table to another tablespace. Normally, I would do
>this with alter table move ..., but the table has a long column and I
>get an error that says that it's an illegal use of a long column. How
>should I move this table? I am on Oracle 8.1.6.0, on Compaq Tru-64
>(Digital) Unix 4.0d.
>
>Thank you,
>
>--
>Scott Canaan (srcdco_at_rit.edu)
>"Life is like a sewer, what you get out of it depends on what you put
>into it" - Tom Lehrer
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Scott Canaan
> INET: srcdco_at_ritvax.isc.rit.edu
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
 |
 |