Solution is: BYPASS_UJVC
update /*+ BYPASS_UJVC */ (Select AB.COUNTRY_SRNO as AB_COUNTRY_SRNO,AB.COUNTRY_DESC as AB_COUNTRY_DESC,AC.COUNTRY_SRNO as AC_COUNTRY_SRNO,AC.COUNTRY_DESC as AC_COUNTRY_DESC From
Imigration.Im_Country Ab Join Test.Im_Country Ac
On Ab.Country_Srno=Ac.Country_Srno) t
set t.AB_COUNTRY_DESC =t.AC_COUNTRY_DESC;
update /*+ BYPASS_UJVC */ (Select AB.COUNTRY_SRNO as AB_COUNTRY_SRNO,AB.COUNTRY_DESC as AB_COUNTRY_DESC,AC.COUNTRY_SRNO as AC_COUNTRY_SRNO,AC.COUNTRY_DESC as AC_COUNTRY_DESC From
Imigration.Im_Country Ab Join Test.Im_Country Ac
On Ab.Country_Srno=Ac.Country_Srno) t
set t.AB_COUNTRY_DESC =t.AC_COUNTRY_DESC;