Oracle实现跨服务器操作

　　Sql代码

　　create public database link test_link

　　connect to test

　　identified by &test&

　　using '(DESCRIPTION =

　　(ADDRESS_LIST =

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

　　)

　　(CONNECT_DATA =

　　(SERVICE_NAME = ora9i)

　　)

　　)';

　　create public database link 名字

　　connect to 用户名

　　identified by &密码&

　　using '(DESCRIPTION =

　　(ADDRESS_LIST =

　　(ADDRESS = (PROTOCOL = TCP)(HOST = 地址)(PORT = 端口))

　　)

　　(CONNECT_DATA =

　　(SERVICE_NAME = SID)

　　)

　　)';