ORA-22992 cannot use LOB locators selected from remote tables

SELECT * FROM TBLHTMLSCANNEDIMAGE@LNK_PREVIOUSYEARBALANCE;

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

both 1920 and 2021 in single db. but through link Oracle is not suppporting this

select * from ldccm.TBLCLREQUESTDESCRIPTION@Lnk_Ccm

Workaround

SELECT ( select cmodifymatter from ldccm.TBLCLREQUESTDESCRIPTION@Lnk_Ccm where nrequestno=4)   FROM DUAL;

select pscannedimage From tblscannedimage@lnk_digital;

Workaround

SELECT (select pscannedimage From tblscannedimage@lnk_digital) as pscannedimage  FROM DUAL

SELECT * FROM TBLHTMLSCANNEDIMAGE@LNK_PREVIOUSYEARBALANCE;

Workaround

CREATE MATERIALIZED VIEW MV_TBLHTMLSCANNEDIMAGE AS SELECT * FROM TBLHTMLSCANNEDIMAGE@LNK_PREVIOUSYEARBALANCE;

SELECT * FROM MV_TBLHTMLSCANNEDIMAGE;

Workaround

create temp table in database and insert into it then select

select *

from test@dblink;

 create global temporary table testglobal

on commit delete rows

as select * from test@dblink;

select * from testglobal;

 insert into testglobal

select y from test@dblink;

select * from testglobal ;