查看创建dblink所需权限 sqlplus / as sysdba select * from user_sys_privs t where t.privilege like upper('%link%'); 给相应的用户授权 grant drop public database link, create database link, create public database link to... Read More
查看现存镜像目录 select * from dba_directories; 创建镜像目录 create or replace directory my_dir as 'local_dir' ; 把镜像目录的权限赋予所需用户 grant read,write on directory my_dir to oracle_user_name; 创建dblink create public da... Read More