Oracle data Pump three-step data

From a library user UA guide data to B library user UB

1. Export

EXPDP ua/[email protected]/orcl schemas=ua directory=data_pump_dir dumpfile=ua.dmp logfile=ua.log

Schemas the list of scenarios to export, unspecified Shime considers the current logged on user scenario

Default in Data_pump_dir When directory is not specified, can be queried by select * from Dba_directories

This machine has the installation of Oracle, can be executed directly in CMD, the command executes after the DMP file is generated on the server

2. Download and upload the DMP from the source server to the specific directory of the destination server

Windows through sharing, disk mapping, Remote Desktop copy

Unix through WINSCP,SECURECRT

3. Import

IMPDP ub/[email protected]/orcl directory=dump_dir dumpfile=ua.dmp schemas=ua Remap_schema=ua:ub

can also be executed natively, importing UA to UB

Oracle data Pump three-step data