优秀是一种习惯 , 生活是一种过程 , 放弃是一种智慧 , 缺点是一种恩惠。
一般是由于基表或view被删除,导致相关同义词错误 。
ORA-01775: looping chain of synonyms
Cause: Through a series of CREATE synonym statements, a synonym was defined that referred to itself.
Action: Change one synonym definition so that it applies to a base table or view and retry the operation.
Oracle中查看同义词:
创建:
create public synonym table_name for user.table_name;
删除:
drop public synonym table_name;
查看所有同义词:
select * from dba_synonyms;
查看具体的同义词,基于同义词名:
select * from dba_synonyms where synonym_name='searches';
查看具体的同义词,基于表名:
select * from dba_synonyms where table_name='searches';
查看用户的表:
select table_name from user_tables;