oracle 建立dblink异常
oracle 建立dblink错误
我根据别人的dblink模仿写的sql，报错：ORA-00954：缺失IDENTIFIED关键字。
求助，哪位大神帮帮忙
------解决方案--------------------
identified是必需的。
创建dblink的语法
CREATE [SHARED][PUBLIC] database link link_name
[CONNECT TO [user][current_user] IDENTIFIED BY password]
[AUTHENTICATED BY user IDENTIFIED BY password]
[USING 'connect_string']
我根据别人的dblink模仿写的sql，报错：ORA-00954：缺失IDENTIFIED关键字。
求助，哪位大神帮帮忙
------解决方案--------------------
identified是必需的。
创建dblink的语法
CREATE [SHARED][PUBLIC] database link link_name
[CONNECT TO [user][current_user] IDENTIFIED BY password]
[AUTHENTICATED BY user IDENTIFIED BY password]
[USING 'connect_string']