sati_82 wrote:
> 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

Basically the first hit on google web (search: ORA-00997) describes
this problem, and this http://www.dbaxchange.com/3_4_longdatatypes.htm
looks like a nice description and workaround to me.

- cheers -