Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

How to trace SYNONYM definition?

Status
Not open for further replies.
SilverStray

SilverStray

Programmer
Oct 25, 2001
47
AU
Hi,

In the USER_OBJECTS table, I can see which objects are of type SYNONYM. But how do I know from which table, schema and db link it was created for? Are there other db tables which can give me this information?

thanks in advance!
 
Sort by date Sort by votes

i found the answer to my question.
The table to look into is USER_SYNONYMS.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

faizsaadq
  • Locked
  • Question
How to call crystal reports XI from Oracle Forms 10G
Replies
1
Views
146
oradba101
oradba101
latha9
  • Locked
  • Question
How to improve Execution time
Replies
3
Views
85
BJCooperIT
BJCooperIT
FreeAgentTempAcc
  • Locked
  • Question
How best to integrate Oracle Forms with a .NET app?
Replies
0
Views
52
FreeAgentTempAcc
FreeAgentTempAcc
kaburia
  • Locked
  • Question
How to display a long datatype variable in a message function
Replies
0
Views
66
kaburia
kaburia
jschodde
  • Locked
  • Question
Need Help to Clean Up Phone Numbers
Replies
2
Views
93
jschodde
jschodde

Part and Inventory Search

Sponsor

Back
Top