Copying an entire table that has a LONG field.

Hi,

I'm trying to copy all the information from one table to another, using
the next command:

insert into table_cp select * from table;

then I get this error msg: ORA-00997: illegal use of LONG datatype, it seems
that this operation does not work b/c the table have one column of type LONG.
Does somebody know if there's a workaround for this problem, I haven't been able to found any relevant in the documentation. (I can always write
an small program but I want to avoid doing it if possible).

Thanks in advance.

andres Received on Fri Jun 29 2001 - 23:30:07 CEST