SELECT T1.*
     FROM ROM_TST T1
     JOIN TABLE2@DBLINK T2
       ON T1.ID = T2.ID

   SELECT T1.*
     FROM ROM_TST T1
     JOIN TABLE2@DBLINK T2
       ON T1.ID = T2.ID

SELECT T1.ID
     FROM ROM_TST T1
     JOIN TABLE2@DBLINK T2
       ON T1.ID = T2.ID

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

   CREATE TABLE TEST_TBL AS
   SELECT T1.* FROM
   ROM_TST T1
   JOIN MBANK.TB_OFFERS@CLON_DBLINK_CRM T2
   ON T1.EID = T2.EID;

 
CREATE TABLE TEST_TBL AS
   SELECT T1.* 
    FROM ROM_TST T1
    JOIN TABLE2@DBLINK T2
      ON T1.ID = T2.ID;

CREATE TABLE TEST_TBL AS
   SELECT T1.*
     FROM ROM_TST T1, TABLE2@DBLINK T2
       WHERE T1.ID = T2.ID