Re: Create table with long datatype
From: Andrew Simkovsky <asimkovsky_at_msn.com>
Date: Wed, 18 Apr 2001 09:08:23 -0400
Message-ID: <#pGKH2GyAHA.344_at_cpmsnbbsa07>
Date: Wed, 18 Apr 2001 09:08:23 -0400
Message-ID: <#pGKH2GyAHA.344_at_cpmsnbbsa07>
LONG datatypes are very limited. You cannot do CTAS, or even SQL*Plus COPY. Also, they cannot be replicated.
Andrew Simkovsky
Pipeline SYSOP
www.revealnet.com
Surf the RevealNet Pipeline!
Lois wrote in message ...
>Hi,
>
>I tried to create a table with the same structure as the plan_table. Kindly
>tell me what's wrong with the long datatype? Thanks.
>
>SQL> create table p_t as select * from plan_table where 0=1;
>create table p_t as select * from plan_table where 0=1
> *
>ERROR at line 1:
>ORA-00997: illegal use of LONG datatype
>
>Regards,
>Lois
>
>
>
Received on Wed Apr 18 2001 - 15:08:23 CEST