今天測試oracle stream 建立database link 出現如下錯誤:

[@more@]

SQL> create database link test.com.cn connect to scott identified by oracle using 'test';

Database link created.

SQL> select * from emp@test.com.cn;
select * from emp@test.com.cn
*
ERROR at line 1:
ORA-01017: invalid username/password; logon denied
ORA-02063: preceding line from TEST

在網上baidu之後發現密碼需要加上雙引號。奇怪，為什麼要加上呢????

SQL> drop database link test.com.cn;

Database link dropped.

SQL> create database link test.com.cn connect to scott identified by "oracle" using 'test';

Database link created.

SQL> select * from emp@test.com.cn
2 ;

EMPNO ENAME JOB MGR HIREDATE SAL COMM DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
7369 SMITH CLERK 7902 17-DEC-80 800 20
7499 ALLEN SALESMAN 7698 20-FEB-81 1600 300 30
7521 WARD SALESMAN 7698 22-FEB-81 1250 500 30

ORA-01017: invalid username/password; logon denied ORA-02063: preceding line from TEST

相關文章