| 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
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.0BDDE610
Content-Type: text/plain;
charset="iso-8859-1"
Another way is to use copy command to copy into the table with different name, drop original table and rename new table. Of cource care should be taken of indexes and constraints.
Alex Hillman
-----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.0BDDE610 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.2448.0"> <TITLE>RE: Need to move a table with a long</TITLE> </HEAD> <BODY> <P><FONT SIZE=3D2>Another way is to use copy command to copy into the = table with different name, drop original table and rename new table. Of = cource care should be taken of indexes and constraints.</FONT></P> <P><FONT SIZE=3D2>Alex Hillman</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:25:29 CST
 |
 |