访问Oracle数据链路的blob字段值

访问照片表select * from zp@dblink1 where a1="11111";会报错：ora-22992 无法使用从远程表选择的LOB定位器改为以下方法：方法一：
drop table temp
Create table temp as select * from zp@dblink1 where a1="002";
select * from temp; 方法二：--创建表只需执行一次
Create global temporary table temp on commit delete rows as select * from zp@zhplink where 1=2;
Create table temp2 as select * from temp where 1=2;--可以多次执行insertinsert into temp select * from zp@zhplink where gmsfhm="140502199102260519";
insert into temp2 select * from temp;select * from temp2;更多Oracle相关信息见Oracle 专题页面 http://www.linuxidc.com/topicnews.aspx？tid=12本文永久更新链接地址