如何建立dblink?如何使用?

using后面的参数是你的服务名

查询时：

select ... from tb@ "qq"

ORARichard at 2005-1-24 11:44:49 >

ORARichard(没钱的日子......) 兄双星了:)

恭喜恭喜!

liuyi8903 at 2005-1-24 12:15:42 >

Connect sharing/****@ mydb_10.7.43.32是可以连接的,

为什么

CREATE PUBLIC DATABASE LINK "QQ" CONNECT TO "SHARING" IDENTIFIED by "**********" USING 'MYDB_10.7.43.32'

测试时提示:

The Database Link is not active.

ORA-12154: TNS:could not resolve the connect identifier specified ?

castle2004 at 2005-1-24 12:30:02 >

先在net manager中为本地配置一个服务名（连接你要连的机器），假定刚配置的服务命名为aaa,

CREATE PUBLIC DATABASE LINK QQ

CONNECT TO USER IDENTIFIED BY PASS

USING 'aaa';

比如想在本机查询aaa机器上的table1表，建议建立一个同义词

CREATE SYNONYM TABLE1（本机的统一词名） FOR [schema.]table1@ QQ;

以后查此表 直接 select * from table1 where......即可

nuno_hh at 2005-1-24 12:41:15 >

触发器有错误:

BEGIN

IF DELETING THEN

DELETE hr01@ qq WHERE DayTypeCode = :OLD.DayTypeCode;

end if;

END;

sql语句有什么问题,提示错误:

Error

Failed to commit: 索引中丢失 IN 或 OUT 参数:: 1

如何解决?

谢谢!

castle2004 at 2005-1-24 13:57:24 >