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