How to Insert values into table using select, with a LONG datatype?
I am inserting data to a table from another table(in another DB)with a column as LONG datatype.
First, I used "create table table1 as select * from table2@DBLINK", one column in table2 is LONG datatype, I got the error message of ora-00997: illegal use of long datatype.
Second, I created the empty table1 first, and defined the column as CLOB datatype, then, I used the command "insert into table1 select * from table2@DBLINK", I still got the error message of "illegal use of long datatype".
Could anyone tell me how to slove the problem? Thank you very much.