Oracle data Pump three-step data

Source: Internet
Author: User

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.