Hello Oracle Team,
Let's say the following scenario:
I have set up a local Dblink called "DbL" for a User_A of a DB_A which connects to the remote User_B of a DB_B.
In addition, there is another User_C part of the same DB_B.
In User_B there is a synonym that's called- let's say' - "SetLableVW" and points to User_C."SetLabelVw" view.
My problem is when connected from User_A,the following query doesn't work:
select * from "SetLabelVw"@DbL -- this tries to execute the User_C view "SetLabelVw" from the synonym "SetLabelVw" located in User_B
The error says:
ORA-12454: connect failed because target host or object does not exist
Is it right that DBLink allows access to remote "synonyms"?? or I've missed something here?
Thank you in advance!
PS: The DBlink I'm using a local (not Public)