I'm familiar with the issue behind ORA-01775: looping chain of synonyms, but is there any trick to debugging it, or do I just have to "create or replace" my way out of it?
有没有办法查询模式或其他什么来找出公共同义词的当前定义是什么?
Is there a way to query the schema or whatever to find out what the current definition of a public synonym is?
更棒的是图形工具，但在这一点上，任何东西都会有所帮助.
Even more awesome would be a graphical tool, but at this point, anything would be helpful.
推荐答案
事实证明，问题实际上不是同义词的循环链，而是同义词指向不存在的视图这一事实.
As it turns out, the problem wasn't actually a looping chain of synonyms, but the fact that the synonym was pointing to a view that did not exist.
在这种情况下，Oracle 显然会出错为循环链.
Oracle apparently errors out as a looping chain in this condition.
