远程连接数据库的问题 本地NT下ORACLE要通过链路连接远程数据库,请问如何建立与远程数据库的连接串(都是ORACLE) 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 1、在本地建立TNSNAME,指向对方DuiFang = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = Ora) ) ) 2、建数据库链接create database link 链接名 connect to 对方用户名 identified by 对方口令; 操作对方库:SELECT * FROM tablename@链接名 nt 下找到TNSNAMEs.ora文件,用记事本打开加入下面代码test = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521)) --修改10.1.1.2为目的数据库的IP) (CONNECT_DATA = (SERVICE_NAME = Ora) --修改Ora为目的数据库的实例名) ) 这样就得到了TEST连接串测试sql>conn system/manager@test 数据库在机房,只有一个ORACLE用户,无法直接进行文件操作 **Find the file mentioned above and then write codes below in it****create local instance**LocalInstance = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = objectip)(PORT = objectport)) ) (CONNECT_DATA = (SERVICE_NAME = Name) ) ) **create link**create database link linkname connect to objectname identified by objectpassword Enterprise Manager 无法连接到数据库实例 给视图插入数据的一个问题 导入失败,为什么? 一道面试题 oracle 无故多了几个表,且有些type 无法删除 ,注:不久前电脑停电一次,会不会有什么关系 关于MERGE编译错误,请帮助解决 windowsXP下oracle8.0.5的启动问题 start with... connect by ...语句性能优化 怎样入门Oracle数据库的学习?高人指点,介绍基本好书。 新手后台请问下如何优化一下oracle查询语句呀 跪求:怎样把日期字段的日期值一天不漏的显示出来 50 分请教一个问题
DuiFang =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = Ora)
)
) 2、建数据库链接
create database link 链接名 connect to 对方用户名 identified by 对方口令;
SELECT * FROM tablename@链接名
加入下面代码
test =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.1.1.2)(PORT = 1521)) --修改10.1.1.2为目的数据库的IP
)
(CONNECT_DATA =
(SERVICE_NAME = Ora) --修改Ora为目的数据库的实例名
)
)
这样就得到了TEST连接串
测试
sql>conn system/manager@test
**create local instance**
LocalInstance =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = objectip)(PORT = objectport))
)
(CONNECT_DATA =
(SERVICE_NAME = Name)
)
) **create link**
create database link linkname connect to objectname identified by objectpassword