Oracle数据库链接出现错误 [英] Oracle Database link with error

问题描述

我正在尝试创建一个从Oracle服务器到另一个服务器的数据库链接. 我正在使用的命令是:

I'm trying to create a database link form an Oracle server to another. The command I'm using is:

 create public database link mylink connect to myuser identified by 0000 authenticated by myuser identified by 0000 using 'myTNSNameRemoteServer';

sqlplus给我这个错误:

sqlplus give me this error:

ERROR at line 1:
ORA-00933: SQL command not properly ended

在第一个实例的密码的第一个字符下插入"*".

Putting the '*' under the first character of the password in its first instance.

我有办法逃脱吗?

谢谢

推荐答案

解决方案是用双引号引起来:

The solution was to double quote the password:

create public database link mylink connect to myuser identified by "0000" authenticated by myuser identified by "0000" using 'myTNSNameRemoteServer';

这篇关于Oracle数据库链接出现错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！