CREATE DATABASE LINK link_name(任意启名) CONNECT TO username (用户名) IDENTIFIED BY password (密码) USING sql_string; (在TNS里设置好的名称如 ...USING 'oracle_db2' ) 有加单引号吗?
直接用名称using 'DEMOtdb'不行才换成连接串的CONNECT TO username (用户名) IDENTIFIED BY password (密码) 这两项是通过PLsql界面设置的
最好配置TNS,在DB SERVER上,然后, create database link TDB_PJ_ND_OP_MANAGER connect to NDPJ identified by NDPJ using 'demotdb'
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.2.73)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hmisb)
)
)
tnsping demotdb 正常create database link TDB_PJ_ND_OP_MANAGER.US.ORACLE.COM
connect to NDPJ identified by NDPJ
using '(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.2.73)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = hmisb)
)
)';
CONNECT TO username (用户名)
IDENTIFIED BY password (密码)
USING sql_string; (在TNS里设置好的名称如 ...USING 'oracle_db2' )
有加单引号吗?
IDENTIFIED BY password (密码)
这两项是通过PLsql界面设置的
create database link TDB_PJ_ND_OP_MANAGER
connect to NDPJ identified by NDPJ
using 'demotdb'
DB SERVER上用sqlplus 连接DEMOTDB 看看.
我想每天都要向远程数据库传输数据,具体的是通过DBLINK建立远程数据表的同义词,连接远程数据库是通过拨号连接的,现在可以通过在服务器端拨号并能顺利传输,我想把传输放在客户端,因为服务器在机房,放在服务器传输比较麻烦,每次都要通过服务器拨号,我想以客户端为桥梁通过客户端拨号把数据传输到远程数据库。不知道我说的详细不详细
select sysdate from dual@link_name;
啥结果?