今天在做dblink查数据的时候报错:
ORA-22992: cannot use LOB locators selected from remote tables
因为该表中存在blob类型的列
解决办法:
create table tsalesorder as select SIGNATURELABELIMAGE from tsalesorder@ESCALADE19
或者
create global temporary table tsalesorder
(
X BLOB
)
on commit delete rows;
insert into tsalesorder select SIGNATURELABELIMAGE from tsalesorder@ESCALADE19 where rownum<3;
这样就可以了