|
-
 Originally Posted by bazza
Please don't ask why I want to do the following, I know its crap.
But is it possible to do:
From DB1, query remote synonym x, via a db link on DB2.
On DB2, synonym X references by another db link a sequence on DB3
I've tried setting this up but keep getting ora-2289. Looking this up, leads me to believe this isn't possible. I know I could just go from DB1 to DB3, but this will involve some code changes (trust me, you don't want to know why).
Thoughts welcome.
Bazza
If you have the permissions, conceptually it would work.
Jeff Hunter
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|
Reply With Quote