Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> AW: Problem with with insert select from clause

AW: Problem with with insert select from clause

From: Bachmann, Henrik <Henrik.Bachmann_at_bim-consulting.de>
Date: Fri, 15 Sep 2000 09:30:00 +0200
Message-Id: <10620.117067@fatcity.com>


Hi!

You can use the export/import utilities.

Best regards

Henrik Bachmann                    =

mailto:Henrik.Bachmann_at_bim-consulting.de
B.I.M.-Consulting Magdeburg        http://www.bim-consulting.de/
D-39124 Magdeburg                 =20


> -----Urspr=FCngliche Nachricht-----
> Von: Helmut Daiminger [mailto:hdaiminger_at_vivonet.com]
> Gesendet: Donnerstag, 14. September 2000 20:31
> An: Multiple recipients of list ORACLE-L
> Betreff: Problem with with insert select from clause

>=20
>=20

> Hi!
>=20

> Are there any limitations to using the LONG datatype in an=20
> insert/select
> statement?
>=20

> insert into scott.tbsql
> select * from demo.tbsql where sqlid between 6117 and 6123
>=20
>=20

> select * from demo.tbsql where sqlid between 6117 and 6123
> *
> ORA-00997: illegal use of LONG datatype
>=20

> Is there another way that I can move that data in the same=20
> table in another
> user's schema?
>=20

> Thanks,
> Helmut
>=20

> --=20
> Author: Helmut Daiminger
> INET: hdaiminger_at_vivonet.com
>=20

> 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).
Received on Fri Sep 15 2000 - 02:30:00 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US