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>