I am accessing a remote Oracle database via a Data base link:
insert into mytab1(f1, f2, f3)
select f1, to_char(substr(f2, 1, 4000)) f2 , f3 from rem_tab@mydblink;
The above works. The field f2 is a CLOB field in both database tables.
Now I want to run this query:
insert into mytab1(f1, f2, f3) t1 select f1, f2, f3 from rem_tab@mydblink t1_rem
where t1_rem.f1 = t1.f1;
The above does not work. Gives error:
ORA-22992: cannot use LOB locators selected from remote table.
Is it possible to make the 2nd query work?
(I know I could create a view of the table at the remote database end and then select from that view instead of the table -- this solution works but it is not an option for me)