One more point, is there any way to grant permission to an account at the remote database through proxy authentication/authorization through the local db account. Example , consider above scenario:
ALTER USER acc3 GRANT CONNECT THROUGH acc1.
where acc3 - database account at the remote database
acc1 - proxy account in the local database
Check if your database link is working fine. If so is there any error thrown?
Secondly try to create synonyms for the remote table and see if this serves your purpose.
I was able to solve this issue, thanks for your reply though. I implemented follwing steps in my application and it worked
1. created one account and granted permission to create database links.
2. created database link to access the remote database account from local database account
3. Created views for every tables present in the remote database account with the same name.
My application was able to access the remote account.