建立数据库连接
DROP (PUBLIC) DATABASE LINK DBaseLinkToCompany;CREATE (PUBLIC) DATABASE LINK DBaseLinkToCompany CONNECT TO CompanyUserName
IDENTIFIED BY CompanyPassword USING 'TnsToCompany';
查询建立数据连接的表事例
Select * From TableName@ DBaseLinkToCompany
DROP (PUBLIC) DATABASE LINK DBaseLinkToCompany;CREATE (PUBLIC) DATABASE LINK DBaseLinkToCompany CONNECT TO CompanyUserName
IDENTIFIED BY CompanyPassword USING 'TnsToCompany';
查询建立数据连接的表事例
Select * From TableName@ DBaseLinkToCompany
数据库连接字符串可以用NET8 EASY CONFIG或者直接修改TNSNAMES.ORA里定义.数据库参数global_name=true时要求数据库链接名称跟远端数据库名称一样数据库全局名称可以用以下命令查出
SELECT * FROM GLOBAL_NAME;查询远端数据库里的表
SELECT …… FROM 表名@数据库链接名;查询数据库连接
select * from user_db_links;
删除数据库连接
DELETE USER_DB_LINKS;
DROP (PUBLIC) DATABASE LINK DBaseLinkToCompany;
我的操作如下,运行时怎么出错?create database link dblink_rainbow
connect to jh identified by jianghong
Using 'tnsnames'数据库链接已创建。select * from 人事职员表@dblink_rainbowORA-12154: TNS: 无法处理服务名不知为什么出错,是不是还得修改TNSNAMES.ORA,应该怎样修改?
tnsnames.WORLD =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = 255.44.33.11)(Port = 1521))
)
(CONNECT_DATA = (SID = tnsnames))
)