ORA-22992: cannot USE LOB locators selected FROM remote TABLES

ORA-22992: cannot USE LOB locators selected FROM remote TABLES

Error
Error occured while tried to access the SQL query of DBLINK.
ORA-22992: cannot USE LOB locators selected FROM remote TABLES

SELECT sales_item_description
FROM sales_north@SALE_DBLINK
WHERE sales_id = 785;

FROM sales_north@SALE_DBLINK
*

ORA-22992: cannot USE LOB locators selected FROM remote TABLES

Cause
LOB column does not able to check from the DBLINK.

Solution
We cannot access CLOB or BLOB columns from the database link.

This entry was posted in Oracle on by .
Unknown's avatar

About SandeepSingh

Hi, I am working in IT industry with having more than 15 year of experience, worked as an Oracle DBA with a Company and handling different databases like Oracle, SQL Server , DB2 etc Worked as a Development and Database Administrator.

Leave a Reply