Saturday, July 25, 2020

ORA-65510: Distributed LOB operations are not supported on pre-12.2 databases.

Summary
from LD , I m trying to save Blob image in ccm's table with link
select * from ldccm.TBLCLREQUESTDESCRIPTION@Lnk_Ccm;

Error

01~Error Description : ORA-65510: Distributed LOB operations are not supported on pre-12.2 databases.

Method : UpdateEkycdataLine : 46406~0~


Investigation
select * from ldccm.TBLCLREQUESTDESCRIPTION@Lnk_Ccm;

check db version of both database 
lnk_ccm(Distrubted DB) is of 11g
source db in 19c


Reason
Distributed LOB operations are not supported on pre-12.2 databases(11.2.0.3).

19c db should be connected through 19c db to support this.


Solution
upgrade DB.


No comments:

Post a Comment

Followers