Synonym across a database link
Hi Oracle Gurus,
Heres my requirement, -
a] I have two databases ('x' & 'y').
b] On x, I have two schemas ('a' & 'b'), while on 'y', I have
only 1 schema ('c').
c] I have created a synonym in 'b' for all the objects in 'c'
using a database link.
d] Now, on 'b', I am able to access the packages and tables
(only select, - cant describe the tables, since this is not
allowed). that belong to 'c' using the synonyms created.
e] I am now having to create another set of synonyms in 'a'
for the synonyms in 'b'. Essentially, the purpose is to
access the objects in 'c', but not directly.
Oracle is complaining here saying that it does not have
access to creating these synonyms.
It appears, the first level of synonym across a database
link is acceptable, but not the second level
Is there any solution for this? I do have a constraint
because of which I am not being able to create a synonym
from a directly to c.
Graphically..
DB x DB y
------------ ------------
Schema a
|
Synonym for synonyms in b (to access objects in c)
Oracle doesnt allow me to create this.
|
v
Schema b <--Synonyms using DBLINK--> Schema c
No problems
I would appreciate any help on this issue.
Thanks
Ravi Kumar