-
I am having a problem with a synonym for a link that I have between two databases. When I do a count with the synonym I get count = 4 but when I do a count specifying the link name and not the synonym I get the correct count of 3350. Does anyone have any ideas?
-
Check who is the owner of the synonym and whether it is public or private.
The synonym probably refers to table in your or another schema while the link correctly refers to the table in another database.
Why don't you drop all the synonyms with that table name and recreate it with the dblink.
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
|