Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Update rows in remote table thru synonym

user11049754Jul 26 2010 — edited Aug 2 2011
Hello all,

I am new to Apex and I have searched this forum about this issue, but couldn't find any.

Here is what I am trying to do.

I have DB1, where the Apex is installed. And, I would like to access/update data in db2 tables. These are the steps I followed

1. Created a dblink in DB1 to DB2.
2. Created synonym in DB! for TableA of remote table i.e. DB2. create synonym tablea_syn for tablea@dblink1;
3. Now, thru object browser of Apex, I would be able to update/insert/delete records in tableA@dblink. So, I selected synonyms in the object browser, but not able to see any rows that are present in tableA@dblink1. I am bale to see the rows using Toad.
Is it possible to update/delete or insert new rows into remote tables using synonyms thru Apex?

Please help me out with this issue.

Thanks in advance.
This post has been answered by Sam.K on Jul 28 2010
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 30 2011
Added on Jul 26 2010
18 comments
4,664 views