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

通过DB_LINK访问远程表的时候出现
ORA-22992: cannot use LOB locators selected from remote tables
原因是表中含有CLOB字段，由于是在统计库中用到这个表。用不到这个clob字段，我们不访问这个clob字段就可以了。

 

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>