misuse of LONG datatype in an INSERT command

[Cantor]

Hello,

I try to insert a table in another table (two tables are exactly the same) but the type of one field of those tables is LONG datatype.
So I do:

INSERT INTO table1
SELECT * FROM table2@DB_LINK;

It gives the alert:

ORA-00997: illegal use of LONG datatype

How could I solve this problem? Should I insert one field at once? My table is very huge.
The db_link is working, I'm sure of that.

thank you for helping,

Cantor

 

[carp]

LONGs do present a problem.
If this is a one-time effort, you might want to just export from the source table and insert into the target table.

 

[kiranjasti]

Dear Cantor,
A value of datatype LONG was used in a function or in a DISTINCT, WHERE, CONNECT BY, GROUP BY, or ORDER BY clause. A LONG value can only be used in a SELECT clause.

In your DataLink u might have used CONNECT BY
SO u r getting the error.So u cannot copy LONG value across Databases.

This might helps u

Regards
Kiran Kumar Jasti