oracle 9i 建立oracle 10g dblink

在oracle9i的机器的tnsnames.ora里配置10g的服务名为：

ora10g   = 
    (DESCRIPTION   = 
        (ADDRESS_LIST   = 
            (ADDRESS   =   (PROTOCOL   =   TCP)(HOST   =   ip )(PORT   =   1522)) 
        ) 
        (CONNECT_DATA   = 
            (SERVICE_NAME   =   ora10g) 
            (SID   =   ora10g) 
        ) 
    )

然后：

create   database   link   dblink_test    connect   to   username   identified   by   passwd   using   'ora10g ';