Problem with LONG datatype column

Hi,

I need to move one table from one schema to another. Unfortunatelly one of the column is a LONG datatype. I tried to do it in that way: CREATE TABLE destination_table AS SELECT * FROM source_table

and in this way:
First I created Table and then: INSERT INTO destination_table SELECT * FROM source_table

In both cases I received an error ORA-00997. Is there any solution of this problem?

Best regards,
Krystian Received on Fri Sep 01 2006 - 05:04:24 CDT