| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> OT RE: Need to move a table with a long
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C06939.4AFE0E30
Content-Type: text/plain;
charset="iso-8859-1"
You mean, a LONG is a pain in the behind? With the same OWNER?!
Wow, this is really off topic!
-----Original Message-----
From: Rachel Carmichael [mailto:carmichr_at_hotmail.com]
Sent: Monday, December 18, 2000 3:18 PM
To: Multiple recipients of list ORACLE-L
Subject: 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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com 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). ------_=_NextPart_001_01C06939.4AFE0E30 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN"> <HTML> <HEAD> <META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; = charset=3Diso-8859-1"> <META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version = 5.5.2653.12"> <TITLE>OT RE: Need to move a table with a long</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>You mean, a LONG is a pain in the behind? With the = same OWNER?!</FONT> </P> <P><FONT SIZE=3D2>Wow, this is really off topic!</FONT> </P> <P><FONT SIZE=3D2>-----Original Message-----</FONT> <BR><FONT SIZE=3D2>From: Rachel Carmichael [<A = HREF=3D"mailto:carmichr_at_hotmail.com">mailto:carmichr_at_hotmail.com</A>]</F= ONT> <BR><FONT SIZE=3D2>Sent: Monday, December 18, 2000 3:18 PM</FONT> <BR><FONT SIZE=3D2>To: Multiple recipients of list ORACLE-L</FONT> <BR><FONT SIZE=3D2>Subject: Re: Need to move a table with a long</FONT> </P> <BR> <P><FONT SIZE=3D2>well, it's a pain in the behind, but you can export = the table, drop the </FONT> <BR><FONT SIZE=3D2>original, create the table (empty) in the new = tablespace and import with </FONT> <BR><FONT SIZE=3D2>ignore=3DY to ignore the creation error.</FONT> </P> <P><FONT SIZE=3D2>Don't know of any other way, you can't do COPY in = SQL*Plus 'cause you want </FONT> <BR><FONT SIZE=3D2>to keep the same owner.</FONT> </P> <BR> <P><FONT SIZE=3D2>>From: Scott Canaan = <srcdco_at_ritvax.isc.rit.edu></FONT> <BR><FONT SIZE=3D2>>Reply-To: ORACLE-L_at_fatcity.com</FONT> <BR><FONT SIZE=3D2>>To: Multiple recipients of list ORACLE-L = <ORACLE-L_at_fatcity.com></FONT> <BR><FONT SIZE=3D2>>Subject: Need to move a table with a long</FONT> <BR><FONT SIZE=3D2>>Date: Mon, 18 Dec 2000 11:30:42 -0800</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>> I need to move a table = to another tablespace. Normally, I would do</FONT> <BR><FONT SIZE=3D2>>this with alter table move ..., but the table = has a long column and I</FONT> <BR><FONT SIZE=3D2>>get an error that says that it's an illegal use = of a long column. How</FONT> <BR><FONT SIZE=3D2>>should I move this table? I am on Oracle = 8.1.6.0, on Compaq Tru-64</FONT> <BR><FONT SIZE=3D2>>(Digital) Unix 4.0d.</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Thank you,</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Scott Canaan (srcdco_at_rit.edu)</FONT> <BR><FONT SIZE=3D2>>"Life is like a sewer, what you get out of = it depends on what you put</FONT> <BR><FONT SIZE=3D2>>into it" - Tom Lehrer</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>>--</FONT> <BR><FONT SIZE=3D2>>Author: Scott Canaan</FONT> <BR><FONT SIZE=3D2>> INET: = srcdco_at_ritvax.isc.rit.edu</FONT> <BR><FONT SIZE=3D2>></FONT> <BR><FONT SIZE=3D2>>Fat City Network Services -- = (858) 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>>-----------------------------------------------------------= ---------</FONT> <BR><FONT SIZE=3D2>>To REMOVE yourself from this mailing list, send = an E-Mail message</FONT> <BR><FONT SIZE=3D2>>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>>the message BODY, include a line containing: = UNSUB ORACLE-L</FONT> <BR><FONT SIZE=3D2>>(or the name of mailing list you want to be = removed from). You may</FONT> <BR><FONT SIZE=3D2>>also send the HELP command for other information = (like subscribing).</FONT> </P> <P><FONT = SIZE=3D2>_______________________________________________________________= __</FONT> <BR><FONT SIZE=3D2>Get your FREE download of MSN Explorer at <A = HREF=3D"http://explorer.msn.com" = TARGET=3D"_blank">http://explorer.msn.com</A></FONT> </P> <P><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Please see the official ORACLE-L FAQ: <A = HREF=3D"http://www.orafaq.com" = TARGET=3D"_blank">http://www.orafaq.com</A></FONT> <BR><FONT SIZE=3D2>-- </FONT> <BR><FONT SIZE=3D2>Author: Rachel Carmichael</FONT> <BR><FONT SIZE=3D2> INET: carmichr_at_hotmail.com</FONT> </P> <P><FONT SIZE=3D2>Fat City Network Services -- (858) = 538-5051 FAX: (858) 538-5051</FONT> <BR><FONT SIZE=3D2>San Diego, = California -- Public Internet = access / Mailing Lists</FONT> <BR><FONT = SIZE=3D2>---------------------------------------------------------------= -----</FONT> <BR><FONT SIZE=3D2>To REMOVE yourself from this mailing list, send an = E-Mail message</FONT> <BR><FONT SIZE=3D2>to: ListGuru_at_fatcity.com (note EXACT spelling of = 'ListGuru') and in</FONT> <BR><FONT SIZE=3D2>the message BODY, include a line containing: UNSUB = ORACLE-L</FONT> <BR><FONT SIZE=3D2>(or the name of mailing list you want to be removed =Received on Mon Dec 18 2000 - 15:27:15 CST
 |
 |