Home -> Usenet -> comp.databases.oracle -> Create table with long datatype

Create table with long datatype

From: Lois <lpfeng1_at_home.com>
Date: Wed, 18 Apr 2001 18:55:47 GMT
Message-ID: <TqlD6.8898$Jh5.8807139_at_news1.rdc1.sfba.home.com> 






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 - 20:55:47 CEST












Original text of this message