- 用户授权
SQL> grant create public database link,create database link to myAccount;
- 创建dblink
SQL> create database link dblink名(可自动以) connect to 目标用户名 identified by 目标用户密码 using '(DESCRIPTION =(ADDRESS = (PROTOCOL = TCP)(HOST = 10.100.25.14)(PORT = 1521))(CONNECT_DATA =(SERVER = DEDICATED)(SERVICE_NAME = orcl)))';
###using后面是目标数据库的tnsnames.ora
Database link created.
- 确实dblink是否可以正常使用
SQL> select * from 目标用户名.目标用户拥有的表@dblink名;
- 查看dblink
SQL> select owner,object_name from dba_objects where object_type='DATABASE LINK';
或
SQL> select * from dba_db_links;
- 删除dblink
SQL> DROP PUBLIC DATABASE LINK dblink名;
或
SQL> DROP DATABASE LINK dblink名;
注: 适用范围:同实例用户之间、不同实例用户、不同oracle之间