Member Avatar for bmantri

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

  • 2 Contributors
  • 1 Reply
  • 81 Views
  • 10 Hours Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.