ORA-22992: cannot use lob locators selected from remote tables

PassDb_linkWhen accessing a remote table
ORA-22992: cannot use lob locators selected from remote tables
The reason is that the table contains the clob field because it is used in the Statistics library. If this clob field is not used, we will not access this clob field.

 

Connected to Oracle Database 10g Enterprise Edition Release 10.2.0.4.0
Connected as report

SQL> select * From err_log;
Select * From err_log
ORA-22992: cannot use lob locators selected from remote tables

 

SQL> conn ywdb /****
SQL> DESC err_log;
Name type nullable default
--------------------------------------------------------
Id varchar2 (40)
Inputdate date y
Xmlcontent clob y

 

SQL> conn report /*****
SQL> select count (1) From err_log @ test_link;

Count (1)
----------
308267

SQL>