Remote expdp network_link

Remote expdp network_link

EXP imp is often used to export data to oracle databases, but the efficiency and performance are not high. Many auxiliary functions are not powerful,
For example, dynamic file segmentation is not good enough.
The new expdp and impdp provide more powerful functions. After the client uses the EXPDP tool, the exported DUMP
The file is generated on the server. However, the DUMP file can be combined with the NETWORK_LINK parameter of EXPDP.
Generated on the client.
The database files on the remote server are exported to the local device through NETWORK_LINK.
Server A (192.168.3.209)
Server B (127.0.0.1)
Now we use A as the server side and B as the client side for experiments.
1) Create A database connection to server A on server B.
We use pl/SQL to create DB_LIK


SQL SQL code -- Create database link
Create database link DB209.REGRESS. RDBMS. DEV. US. ORACLE. COM
Connect to xxx
Using '(DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)
(HOST = 192.168.3.209) (PORT = 1521) (CONNECT_DATA = (SERVICE_NAME
= XXX) '; 2) create a directory to store the DUMP file.
Cmd: Enter the command window
 

 

Create directory
 

Note that the specified directory E: \ oracle \ folder must be available.
Grant Read and Write Permissions


We can use PL/SQL to view the modified directory SQL code SELECT privilege, directory_name, DIRECTORY_PATH
FROM user_tab_privs t, all_directories d
WHERE t. table_name (+) = d. directory_name
Order by 2, 1;

 
3) export the SQL code expdp xxx/xxx @ xxxx directory = dump dumpfile = aaa % u. dmp logfile = aa. log of the xxx/xxx User table in server A from user xxx/xxx on server side B
Filesize = 50 m network_link = db209 cmd run the following command
Data XXX01.DMP XXXX02.DMP... and logs are written in the E: \ oralce \ directory.