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.
Click Here to Expand Forum to Full Width