Oracle EXPDP Export Remote data to a local

1. Create a new user test on the local database and grant the following basic permissions (try not to authorize more, such as local permissions larger than remote, will cause the export failed, depressed!). ):

Grant connect to test;
Grant resource to test;
Grant CREATE TABLE, create database link to test;
Grant create session to test;

2. Create a remote Dblink

Create public database link linkname_xxx connect to username identified by password
Using ' (DESCRIPTION = (Address_list = (ADDRESS = (PROTOCOL = TCP)
(HOST = 218.65.236.85) (PORT = 1521))) (Connect_data = (service_name
= Orcldev))) ';

3. Create the Export file directory and authorize the test

Create directory Dump_dir as ' E:\oracle_dump ';

Grant Read,write on directory dump to YX;

4. Execute EXPDP command

EXPDP Test/[email protected] directory=dump_dir dumpfile=eas32.dmp network_link=linkname_xxx

Oracle EXPDP Export Remote data to a local