Message-Id: <10758.127978@fatcity.com> From: Alex Hillman Date: Wed, 31 Jan 2001 16:37:06 -0500 Subject: RE: Copying some rows from a table having a long datatype column. 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_01C08BCD.F53DE8A0 Content-Type: text/plain; charset="windows-1252" Also if you need selected row you can create a view based on required select statement and use this view in the copy command - did not try this myself but should work. Alex Hillman -----Original Message----- From: Cale, Rick T (Richard) [mailto:RICHARD.T.CALE@saic.com] Sent: Wednesday, January 31, 2001 3:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: Copying some rows from a table having a long datatype column. Use the COPY command. It will allow you to insert a long from another table. Rick > -----Original Message----- > From: Kumar, Dharminder [SMTP:Dharminder.Kumar@bmonesbittburns.com] > Sent: Wednesday, January 31, 2001 2:32 PM > To: Multiple recipients of list ORACLE-L > Subject: Copying some rows from a table having a long datatype > column. > > Hi, > I have a requirement like mentioned bellow. > > Table A > > Columns datatype > col1 number > col2 long > > Table B > col1 number > col2 long > > I need to put some rows from table A to table B. > If I use the sqlplus > > sqlplus>insert into A select * from B where B.col1 < 50; > I get the following error. > > ORA-00997: illegal use of LONG datatype > > Is there any other way to accomplish this goal. > > Thanks. > > Dharminder Kumar > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kumar, Dharminder > INET: Dharminder.Kumar@bmonesbittburns.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@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: Cale, Rick T (Richard) INET: RICHARD.T.CALE@saic.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@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_01C08BCD.F53DE8A0 Content-Type: text/html; charset="windows-1252" Content-Transfer-Encoding: quoted-printable RE: Copying some rows from a table having a long datatype = column.

Also if you need selected row you can create a view = based on required select statement and use this view in the copy = command - did not try this myself but should work.

Alex Hillman

-----Original Message-----
From: Cale, Rick T (Richard) [mailto:RICHARD.T.CALE@saic.com]
Sent: Wednesday, January 31, 2001 3:21 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Copying some rows from a table having a = long datatype
column.


Use the COPY command. It will allow you to insert a = long from another table.

Rick

> -----Original Message-----
> From: Kumar, Dharminder = [SMTP:Dharminder.Kumar@bmonesbittburns.com]
> Sent: Wednesday, January 31, 2001 2:32 = PM
> To:   Multiple recipients of list = ORACLE-L
> Subject:      Copying = some rows from a table having a long datatype
> column.
>
> Hi,
> I have a requirement like mentioned = bellow.
>
> Table A
>
> Columns       = datatype
> col1  =         number
> col2  =         long
>
> Table B
> col1  =         number
> col2  =         long
>
> I need to put some rows from table A to table = B.
> If I use the sqlplus
>
> sqlplus>insert into A select * from B where = B.col1 < 50;
> I get the following error.
>
> ORA-00997: illegal use of LONG datatype
>
> Is there any other way to accomplish this = goal.
>
> Thanks.
>
> Dharminder Kumar
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Kumar, Dharminder
>   INET: = Dharminder.Kumar@bmonesbittburns.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@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: Cale, Rick T (Richard)
  INET: RICHARD.T.CALE@saic.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@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 =