This has always been a nuisance. There you are – getting all the bells and whistles with LOBs…until a database link enters the room 
--
-- Database: DB11
--
SQL> create table t ( id int, c clob );
Table created.
SQL> insert into t values (1,rpad('x',32000,'x'));
1 row created.
SQL> select *
2 from t;
ID C
---------- --------------------------------------------
1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
--
-- Database: anywhere except DB11
--
SQL> select *
2 from t@db11;
ERROR:
ORA-22992: cannot use LOB locators selected from remote tables
Well that sucks. But look what has snuck its way into 12.2 !
SQL> select *
2 from t@db122;
ID C
---------- --------------------------------------------
1 xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx
There is a whole chapter on it here in the official docs. Very nice indeed.
Leave a Reply