oracle如何查数据链路,访问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;

--可以多次执行insert

insert into temp select * from zp@zhplink where gmsfhm='140502199102260519';

insert into temp2 select * from temp;

select * from temp2;