xywuyiba7 发表于 2018-9-10 09:47:29

oracle db link

　　一、 Create database link
　　createpublicdatabaselink TO_XXX
　　connectto userObj
　　using'(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = XX.XX.XX.XX)(PORT= 1526)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME =XX)))';
　　说明：

[*]　　userObj是一个用户
　　二、Create the user
　　createuser userObj

　　>　　defaulttablespaceXX
　　passwordexpire
　　-- Grant/Revoke system privileges
　　三、使用dblink
　　SELECT * FROM table_name@ TO_XXX;

页: [1]
查看完整版本: oracle db link