ORA-00997 Create as select * from with LONG

From: Christian Greven <greven.christian_at_baufeldt.de>
Date: Thu, 27 Jan 2000 10:54:09 +0100
Message-ID: <86p4gm$ktj$1@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 Thu Jan 27 2000 - 03:54:09 CST