Hi,
I am working with both Oracle RDBMS 11g and 12c.
I have a remote database server A and a local database server B.
On the remote database server A there are some tables containing BLOBs.
When using a database link from local database server B, I get the following error:
SQL> select id, decription, doc from staging_boogs@to_byblos_test2;
ERROR:
ORA-22992: cannot use LOB locators selected from remote tables
no rows selected
where doc is a BLOB.
Probably it is not possible to pass the whole BLOB through the database link.
Does someone know a technique how to select through a database link a BLOB from a remote database?
Not by creating locally a copy of the table that contains the LOB. I know it is possible.
Thanks by advance for sharing your experience.
Kind Regards