试试下面的方法: CREATE PUBLIC DATABASE LINK ora10g CONNECT TO scott IDENTIFIED BY "tiger" USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST = 10.10.71.156)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ora10g)))';
50分是我的了 ORACLE9I登陆10G 在OEM中 只能用SYS SYS AS SYSDBA 登录
CREATE PUBLIC DATABASE LINK ora10g CONNECT TO scott IDENTIFIED BY "tiger" USING '(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST = 10.10.71.156)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = ora10g)))';
ORACLE9I登陆10G
在OEM中 只能用SYS
SYS
AS SYSDBA
登录
测试成功后,再建db_link。
不好意思,这个我已经解决了,重点是做dblink 因为这个登录10g的用户是dba,所以我怕会有些问题,或许是9i dblink 10g的问题