This content has been marked as final. Show 3 replies
You can directly update the SALES2.SALARY@PROD2_LNK table as below:
update SALARSALES2.SALARY@PROD2_LNKY set pay=1000 where employee_id=101;
now if you check it will update salary table
same thing do for PROD2 scenario
4. But when I update:Use the following :
SQL> update SALARY set pay=1000 where employee_id=101; --> OK
SQL> commit; --> OK
But when I select the pay of employee_id 101, it is not updated.
(the same scenario happens in PROD2 when i try to update EMPLOYEES)
update SALARY@PROD2_LNK set pay=1000 where employee_id=101
Since you are not using the database link 'PROD2_LNK', the salary table in PROD1 db is getting updated and hence facing the issue.
Please use the db link it will solve your purpose.
Edited by: Vedant.. on Dec 4, 2012 10:51 AM
The user reported an incorrect information. Turns out the setup is actually working properly. Update on the base object or update on the synonym actually works fine.
Thanks for all the feedback.