cannot use LOB locators selected from remote tables
来源:互联网 发布:手机淘宝苹果版本下载 编辑:程序博客网 时间:2024/06/06 00:43
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>
- ORA-22992: cannot use LOB locators selected from remote tables
- cannot use LOB locators selected from remote tables
- ORA-22992 cannot use LOB locators selected from remote tables(转)
- Oracle ORA-22992 cannot use LOB locators selected from remote tables解决
- Use LOB Storage
- Remote desktop cannot verify
- java How to Use Tables
- ORA-12032: cannot use rowid column from materialized view log on "DCS_BIZ"."TMP_12"
- Cannot checkout from svn: Cannot run program "svn"和 Can't use Subversion command line client:svn
- <Xcode>Xcode cannot run using the selected
- Xcode Cannot Run on the Selected Destination
- Xcode cannot run using the selected device
- Cannot run on the selected destination
- Xcode cannot run using the selected device
- Xcode cannot run using the selected device
- Xcode cannot run using the selected device.
- Xcode cannot run using the selected device.
- Cannot launch the remote executable
- 地图开发中如何获取安全码
- AC 自动机 hdu2222
- 这是vs2015 update2的bug么
- Java中关于Short,byte越界需要强转,int,long越界自动转为最小值。
- 【Java】异常处理
- cannot use LOB locators selected from remote tables
- javascrip将对象转换成json字符串
- netty 私有协议开发
- Eclipse上Hadoop开发环境搭建
- 【Java】抽象类和接口
- MVP模式在Android中的使用
- 一些前端开发实用的函数—1(jquery)
- 2016年中国电子信息百强企业出炉:华为居首
- NodeJS学习系列课程笔记(NodeJs 快速上手+用法示例)