expdp从远程数据库导入到本地

--从远程服务器导通过expdb导出数据到本地的方法

1.在本地数据库新建一个用户 tests ,并授予以下基本权限(尽量不要多授权，如本地权限大于远程，会导致导出失败！！！！)

create  user tests identified by 123456;

grant connect to tests;

grant resource to tests;

grant create table,create database link to tests;

grant create session to tests;

--2、创建远程dblink

create public database link  ali_server

connect to username identified by "password" using 

'(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = IP地址)(PORT = 1521)))(CONNECT_DATA = (SERVICE_NAME = 数据库实例)))';

--测试DBLINK是否成功

select * from dual@ali_server;

--3.创建导出文件目录，并授权给test

create directory dump_dir as 'e:\oracle_dump';

--删除创建的目录

drop directory dump_dir;

--给目录授权读写权限

grant read,write on directory dump_dir to tests;

--4.执行expdb导出命令

expdp tests/123456@dbms directory=dump_dir dumpfile=gyjkzd.dmpdp network_link=ali_server;