[size=large][color=red][b]database link[/b][/color][/size]
--访问database link时报如下错误:ORA-01017: invalid username/password;logon denied 原因是密码需要用引号”“引起来
create public database link dblinkname
connect to username identified by "password"
using 'connect_string';
--ora-02024:删除database link,原因是需要public关键字
drop public database link to_brmdb.us.oracle.com
--database link ORA-02019: 未找到远程数据库的连接说明
--源脚本
create database link dblinkname connect to username identified by "password" using 'connect_string';
--修改为
create database link dblinkname
connect to username identified by "password"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = connect_string)
)
)';
--访问database link时报如下错误:ORA-01017: invalid username/password;logon denied 原因是密码需要用引号”“引起来
create public database link dblinkname
connect to username identified by "password"
using 'connect_string';
--ora-02024:删除database link,原因是需要public关键字
drop public database link to_brmdb.us.oracle.com
--database link ORA-02019: 未找到远程数据库的连接说明
--源脚本
create database link dblinkname connect to username identified by "password" using 'connect_string';
--修改为
create database link dblinkname
connect to username identified by "password"
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = connect_string)
)
)';