copy data to a new table

I want to copy all the data in table1 to an identical table called table2.  One of the columns is datatype LONG. I have tried

        create table table2 as select * from table1 ;

and creating the table and then

        insert into table2 (select * from table1);

Both of these give me ORA-00997: illegal use of LONG datatype. Does anyone have any suggestions?

Marg Received on Wed Aug 12 1998 - 13:42:17 CDT