DBLINK简述
A database link is a schema object in one database that enables you to access objects on another database. The other database need not be an Oracle Database System.
语法/写法
CREATE [ SHARED ] [ PUBLIC ] DATABASE LINK dblink |
关键字
|
示例1 CONNECT TO REMOTE_USER_CODE IDENTIFIED BY USER_PASSWORD USING '192.168.0.8:1521/SID'; 示例2 CREATE SHARED DATABASE_LINK DB_LINK_NAME CONNECT TO REMOTE_USER_CODE_1 IDENTIFIED BY USER_PASSWORD_1 AUTHENTICATED BY REMOTE_USER_CODE_2 IDENTIFIED BY USER_PASSWORD_2 USING '192.168.0.8:1521/SID' 示例2_1 CREATE SHARED DATABASE_LINK DB_LINK_NAME AUTHENTICATED BY REMOTE_USER_CODE_2 IDENTIFIED BY USER_PASSWORD_2 USING '192.168.0.8:1521/SID' 注意,示例2中出现两个REMOTE_USER_CODE分别是REMOTE_USER_CODE_1\REMOTE_USER_CODE_2,因为指定了SHARED关键字必须要求有AUTHENTICATION而这时CONNECT TO可以省略(如示例2_1)。 |
用法
|
参考资料
- Oracle Documentation Library
- http://download.oracle.com/docs/cd/E11882_01/server.112/e17118/statements_5005.htm#SQLRF01205