Home » SQL & PL/SQL » Client Tools » Cannot see synonyms in toad.
Cannot see synonyms in toad. [message #122745] Wed, 08 June 2005 06:36 Go to next message
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 Go to previous message
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.
Previous Topic: how to find port number at which isqlplus service is running
Next Topic: Test Stored Procedure in TOAD
Goto Forum:
  


Current Time: Wed Aug 05 20:56:02 CDT 2020