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

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Thu, 27 Jan 2000 11:25:59 +0100
Message-ID: <948968877.1904.0.pluto.d4ee154e@news.demon.nl>

Use the sql*plus COPY statement.

Hth,

--
Sybrand Bakker, Oracle DBA
Christian Greven <greven.christian_at_baufeldt.de> wrote in message news: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 Thu Jan 27 2000 - 04:25:59 CST