Collected posts: Oracle, SQL, PL/SQL, Performance, Security...(More than 300 blogs)

Affichage des articles dont le libellé est Database link. Afficher tous les articles
Affichage des articles dont le libellé est Database link. Afficher tous les articles

dimanche 29 novembre 2015

ORA-22992: cannot use LOB locators selected from remote tables

 

ORA-22992: cannot use LOB locators selected from remote tables

--- Remote DB
create table CHB_TEST 
(
 DATA CLOB  

);
--- LOCAL DB
select   DATA    from CHB_TEST@<ORACLE_DB_LINK_REMOTE_DB> 

ORA-22992: cannot use LOB locators selected from remote tables

 select dbms_lob.substr@<ORACLE_DB_LINK_REMOTE_DB>( DATA , 4000) from CHB_TEST@<ORACLE_DB_LINK_REMOTE_DB