Oracle建立dblink

標籤：ddr   script   sel   oracle   sele   1.2   sqlplus   base   upper   

1. 查看建立dblink要求的權限

   sqlplus / as sysdba

   select * from user_sys_privs t where t.privilege like upper(‘%link%‘);

2. 給相應的使用者授權

   grant drop public database link, create database link, create public database link to oracle_user_name;

3. 登陸要建立dblink的使用者

   conn oracle_user_name/password

4. 建立dblink

   create database link my_dblink_name

   connect to oracle_user_naem identified by password

   using ‘(DESCRIPTION =

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

   (CONNECT_DATA =

   (SERVER = DEDICATED)

   (SERVICE_NAME = ORCL)

   )

   )‘;

   查看是否建立成功

   select * from dba_db_links;

Oracle建立dblink