|
-
Sequences, synonyms and db links
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
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
|