I've this problem:
create table t1 ( x long );
create table t2 ( x long );
insert into t1 values ( 'test long type' );
1 row created.
insert into t2 select * from t1;
ERROR at line 1:
ORA-00997: illegal use of LONG datatype
How can I issue this error, I need use also dblink with long type.
Please, I do not want to use the copy command.
I know that can solve this problem with a stored procedure or anonymous block.
Have someone any idea?