DaniWeb IT Discussion Community

DaniWeb IT Discussion Community (http://www.daniweb.com/forums/)

- Oracle (http://www.daniweb.com/forums/forum129.html)

- - SYNONYMS (http://www.daniweb.com/forums/thread119350.html)

bmantri

Apr 16th, 2008 1:30 am

SYNONYMS

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

debasisdas

Apr 16th, 2008 6:17 am

Re: SYNONYMS

The synonym becomes invalid if the base table is dropped. You need to drop the synonym manually.

All times are GMT -4. The time now is 10:38 pm.