同义词的循环链
来源:互联网 发布:windows激活密匙在哪里 编辑:程序博客网 时间:2024/04/29 11:07
SQL> select* from dba_synonyms where table_name='t1';
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------
SQL> select * From t1
2 ;
select * From t1
ORA-01775: 同义词的循环链
SQL> select * From bosdata.t1
2 ;
select * From bosdata.t1
ORA-00942: 表或视图不存在
SQL> select *
2 from dba_synonyms
3 where table_owner = 'BOSDATA'
4 and synonym_name in
5 (select a.synonym_name
6 from dba_synonyms a where a.table_owner = 'BOSDATA'
7 minus
8 select object_name from DBA_objects WHERE OWNER='BOSDATA')
9 ;
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------
PUBLIC t1 BOSDATA t1
解决办法:
drop public synonym t1
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------
SQL> select * From t1
2 ;
select * From t1
ORA-01775: 同义词的循环链
SQL> select * From bosdata.t1
2 ;
select * From bosdata.t1
ORA-00942: 表或视图不存在
SQL> select *
2 from dba_synonyms
3 where table_owner = 'BOSDATA'
4 and synonym_name in
5 (select a.synonym_name
6 from dba_synonyms a where a.table_owner = 'BOSDATA'
7 minus
8 select object_name from DBA_objects WHERE OWNER='BOSDATA')
9 ;
OWNER SYNONYM_NAME TABLE_OWNER TABLE_NAME DB_LINK
------------------------------ ------------------------------ ------------------------------ ------------------------------ --------------------------------------------------------------------------------
PUBLIC t1 BOSDATA t1
解决办法:
drop public synonym t1
0 0
- 同义词的循环链
- ora-01775:同义词的循环链
- ORA-01775: 同义词的循环链
- ORA-01775: 同义词的循环链
- ORA-01775: 同义词的循环链
- oracle同义词循环链
- Oracle同义词循环链问题解决
- 同义词+同义词类别+创建同义词+删除同义词+同义词的作用
- oracle的同义词总结
- Oracle同义词的使用
- Oracle的同义词
- Oracle的同义词
- Oracle的同义词
- 同义词的使用
- Oracle的同义词
- Oracle的同义词
- 同义词信息的查询
- Oracle的同义词
- WorldCount程序分析
- 仿照QQ抖一抖的实现——窗口抖动功能
- PAT 1064. Complete Binary Search Tree
- 百度实时推送代码 curl
- java transient简介
- 同义词的循环链
- 图像差分 (IplImage *) 版
- usb 枚举
- java学习笔记(二) -- 基本语法
- js 计时程序
- 程序员的心理疾病
- 安卓APP采用观察者模式实现检测版本更新
- java终止线程
- JS实现ajax 封装成方法