Re: ORA-00997 Create as select * from with LONG

From: Joachim Carlsson <joachim.carlsson_at_neurope.ikea.com>
Date: Fri, 28 Jan 2000 10:21:29 -0000
Message-ID: <86qjv1$6n4$1@mailgate.ikea.com>

You have to reference a long field with rowid. You can´t join with it as a normal field.

/Joachim
Christian Greven wrote in message <86p4gm$ktj$1_at_news07.btx.dtag.de>...
>Hi,
>
>this sql:
>
> create table TMP_KUNDEN tablespace reptmp as select * from KUNDEN
> where kdnr_neu in (select kdnr_neu from REC_KUNDEN_CG)
>
>get's the following error message:
>
> ORA-00997: Illegal use of LONG datatype!
>
>Any workaround? - I need the Long-field!!!
>
>Thanks,
>
>Christian.
>
>------------------------------------------
>Christian Greven
>Baufeldt & Partner GmbH
>Winkelsweg 178 Geb. 20
>40764 Langenfeld
>Germany
>Tel.: 02173/ 9842-0
>------------------------------------------
>
>
Received on Fri Jan 28 2000 - 04:21:29 CST