创建同义词的时候遇到如下错误，现在已搞清楚，特记录下来以备后忘

SQL>conn system/oracle;
SQL> create synonym d for scott.dept;

Synonym created.

SQL> select * from d;

DEPTNO DNAME       LOC
---------- -------------- -------------
      10 ACCOUNTING    NEW YORK
      20 RESEARCH    DALLAS
      30 SALES       CHICAGO
      40 OPERATIONS    BOSTON

SQL> conn scott/oracle;
Connected.
SQL> select * from d;
select * from d
            *
ERROR at line 1:
ORA-00942: table or view does not exist

SQL> select * from system.d;

DEPTNO DNAME       LOC
---------- -------------- -------------
      10 ACCOUNTING    NEW YORK
      20 RESEARCH    DALLAS
      30 SALES       CHICAGO
      40 OPERATIONS    BOSTON
在scott用户下执行select * from d时报错，执行 select * from system.d却不报错

原因：scott用户下执行select * from d时是在scott.d里查找，执行 select * from system.d时，是在system.d下查找，而system.d指向的恰恰是scott.dept...

ITPub博客

关于私有 synonym 的疑惑

最新文章