Red Hat Linux 7
Oracle Database 12.1.0.2
Hello,
I am getting an error when querying a remote table(DB lcms1) from production(DB archicom)
From archicom:
SQL> select * from LYT_CAMPAIGN_MASTER@LYT;
ERROR:
ORA-22992: cannot use LOB locators selected from remote tables
no rows selected
I tried to create a table on archicom as follows
create table lyt_campaign2 as select * from lyt_campaign_master@LYT;
Table got created successfully and I was able to select all data from lyt_campaign2.
I noticed if I select * from LYT_CAMPAIGN_MASTER on DB lcms1, all data could be viewed.
Please advise.
Regards,
Joe