•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the Oracle section within the Web Development category of DaniWeb, a massive community of 374,193 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 3,560 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our Oracle advertiser:
Views: 435 | Replies: 1
 |
•
•
Join Date: Dec 2007
Posts: 9
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
Hello,
I have created a synonym. But later I have dropped the base table which is referenced by this synonym. I thought that the synonym would be dropped automatically. But later I found it exists in all_synonyms and doesnt exist in user_objects dictionary.
When i quried the date from this synonyms it is giving me error as
ORA-01775: looping chain of synonyms
Can you please help me to fix this problem?
Do we need to drop the synonyms manually?
Thanks,
BMantri
I have created a synonym. But later I have dropped the base table which is referenced by this synonym. I thought that the synonym would be dropped automatically. But later I found it exists in all_synonyms and doesnt exist in user_objects dictionary.
When i quried the date from this synonyms it is giving me error as
ORA-01775: looping chain of synonyms
Can you please help me to fix this problem?
Do we need to drop the synonyms manually?
Thanks,
BMantri
|
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
•
•
•
•
•
•
•
•
DaniWeb Oracle Marketplace
Linear Mode
Other Threads in the Oracle Forum
- Previous Thread: Query Report
- Next Thread: Constraint Help Please
