Skip to Main Content

SQL & PL/SQL

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!

Synonym across a database link

50295Mar 13 2002
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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 14 2002
Added on Mar 13 2002
2 comments
496 views