We have a table that contains a CLOB datatype in one of its column. However when i tried to access the table i get the below error.
<b>Table Name:</b> discrete_jobs
(Error starting at line 1 in command:
select * from stg.discrete_jobs@TEST.YODA
SQL Error: ORA-22992: cannot use LOB locators selected from remote tables
22992. 00000 - "cannot use LOB locators selected from remote tables"
*Cause: A remote LOB column cannot be referenced.
*Action: Remove references to LOBs in remote tables.)