sql 代码
- --=============================================================================
- -- Create database link which link to CMM database
- --=============================================================================
- CREATE PUBLIC DATABASE LINK tocmm
- CONNECT TO otapush IDENTIFIED BY cmm
- USING '(DESCRIPTION =
- (ADDRESS_LIST =
- (ADDRESS = (PROTOCOL = TCP)(HOST = 10.168.209.110)(PORT = 1521))
- )
- (CONNECT_DATA =
- (SID = cpad)
- )
- )';
- --
sql 代码
- --=============================================================================
- -- Create synonymous to CMM database link
- -- otatasksubscribers_back
- -- otatask
- --=============================================================================
- CREATE SYNONYM otatask FOR otatask@tocmm;
- CREATE SYNONYM otatasksubscribers_back FOR otatasksubscribers_back@tocmm;
然后就可以用otatask,otatasksubscribers_back作别名调用另外实例的表了...