SQL problem

[Quoted] Hi all,

I had to create a table with this command :

CREATE TABLE ... AS SELECT ... ; but if this is a LONG datatype in the create table , then this request doesn't work.

exemple:

SQL> desc pagereq

 Name                            Null?    Type
 ------------------------------- -------- ----
 PAGEREQ_ID                      NOT NULL NUMBER(10)
 PAGEREQ_NUMPAGE      NOT NULL NUMBER(3)
 PAGEREQ_DATA                                    LONG

SQL> CREATE TABLE pagereq_save AS SELECT * FROM pagereq;

ERROR at line 1:
ORA-00997: illegal use of LONG datatype

Does anyone know what is the correct syntax ? Any help will be appreciated.

Thanks, Received on Fri May 05 2000 - 00:00:00 CEST