| 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: Problem with with insert select from clause
you can't use a LONG in an insert into ... select from statement at all.
doesn't matter if the LONG column is in the where clause or not. I've tried
this more times than I care to remember, because I keep forgetting that :)
>From: Suzy Vordos <lvordos_at_datsit.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: Re: Problem with with insert select from clause
>Date: Thu, 14 Sep 2000 12:50:36 -0800
>
>
>You can use export then import using fromuser= touser=. Or use the copy
>command in SQL*Plus (however, long data >32K will be truncated).
>Functions don't work with longs, if sqlid is the long that would explain
>the error.
>
>Suzy
>
>Helmut Daiminger wrote:
> >
> > Hi!
> >
> > Are there any limitations to using the LONG datatype in an insert/select
> > statement?
> >
> > insert into scott.tbsql
> > select * from demo.tbsql where sqlid between 6117 and 6123
> >
> > select * from demo.tbsql where sqlid between 6117 and 6123
> > *
> > ORA-00997: illegal use of LONG datatype
> >
> > Is there another way that I can move that data in the same table in
>another
> > user's schema?
> >
> > Thanks,
> > Helmut
> >
> > --
> > Author: Helmut Daiminger
> > INET: hdaiminger_at_vivonet.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).
>--
>Author: Suzy Vordos
> INET: lvordos_at_datsit.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).
Share information about yourself, create your own public profile at Received on Thu Sep 14 2000 - 18:16:29 CDT
 |
 |