selecting a long for a insert

Hello all,

I am using;
Oracle8
NT 4 SP3

I am trying to create a simple sql statement which copies the contents of a table
to another identical table.
The formate I am using is;
 insert into project2
  select * from project
However in the project table is field1 varchar2(1024), this field is causing the following error
'ORA-00997: illegal use of LONG datatype'

Question;
Is there any way around this problem, the long datatype is required.

Thankyou
--
Adam Sorati
adams_at_sgen.com.au

SoftGen Australia Received on Thu Mar 18 1999 - 03:14:42 CST