如何调试 ORA-01775:同义词循环链?

How to debug ORA-01775: looping chain of synonyms?(如何调试 ORA-01775:同义词循环链?)

问题描述

我熟悉 ORA-01775 背后的问题:同义词循环链，但是否有任何调试技巧，或者我是否只需要创建或替换"我的方式来解决它?

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.

这篇关于如何调试 ORA-01775:同义词循环链?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持编程学习网！