java dblink_Oracle中添加dblink

select * from dba_objects o where object_type='DATABASE LINK';

drop database link remoteOssc--link名字

select * from risenet_out_user_info@remote

SELECT * FROM GLOBAL_NAME; --查看服务名

create database link remoteOssc  --创建link

--用户名               --密码

connect to user identified by pass

using '(DESCRIPTION =

(ADDRESS_LIST =

(ADDRESS = (PROTOCOL = TCP)(HOST = Ip)(PORT = 1521))

)

(CONNECT_DATA =

(SERVICE_NAME = instance)

)

)';

select * from risenet_out_user_info@remoteossc

posted on 2011-04-26 10:01 soken 阅读(154) 评论(0)  编辑  收藏 所属分类: Oracle