创建DBLINK
建立dblink
在inas_center建立访问Inas_analyse的dblink
用处:从inas_center实时将工单导入inas_analyse用户中。
–建立dlink——————————–
create database link dl_analyse
connect to inas_analyse identified by InAs_178Als
using ’ (DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 134.64.60.178
)(PORT = 1521))
)
(CONNECT_DATA =
(SID = ahjhhis )
(SERVER = DEDICATED)
)
)’;
dblink名称:dl_analyse
inas_analyse:数据库账户
InAs_178Als:数据库密码
134.64.60.178:数据库链接
ahjhhis:数据库名称