| Cannot see synonyms in toad. [message #122745] |
Wed, 08 June 2005 06:36  |
vjeedigunta
Messages: 201
Registered: March 2005
Location: Hyderabad
|
Senior Member |
|
|
Hello,
I created private synonyms in a user and when logged in from toad 7.6 into that user - under schema browser - under synonyms section , I cannot see any of the synonyms !!! why ?
PS : This synonyms are created using the db link pointing to remote db.
My oracle version is 8.1.7.4
Let me know If any one has idea abt this ..
-V
|
|
|
|
| Re: Cannot see synonyms in toad. [message #122830 is a reply to message #122745] |
Wed, 08 June 2005 13:47  |
andrew again
Messages: 2577
Registered: March 2000
|
Senior Member |
|
|
I have seen problems like this before. I think it was related to either having multiple connections open, changing the schema you are browsing using the dropdown list - while connecting through a different schema (to be expected).
You can try capturing the SQL run by Toad to query the synonyms using Tools > Spool SQL > to screen. Copy the queries and run them manually to see what that returns.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
