復制代碼 代碼如下:

catalog =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.137.100)(PORT = 1521))
)
(CONNECT_DATA =
(SID = catalog)
)
)

復制代碼 代碼如下:

$ sqlplus rman/rman
sql> CREATE DATABASE LINK dmp_link CONNECT TO rman IDENTIFIED BY rman USING 'catalog';

復制代碼 代碼如下:

ERROR at line 1:
ORA-01031: insufficient privileges

復制代碼 代碼如下:

SQL> select tname from tab@dmp_link;
SQL> exit;

復制代碼 代碼如下:

$ sqlplus / as sysdba
sql> create or replace directory dmp_dir as '/oracle/dmp';
sql> grant read,write on directory dmp_dir to public;
sql> exit;