Oracle Data Pump Import and export (EXPDP/IMPDP)

Source: Internet
Author: User

--Reference http://www.lanstonwu.com/using-datapump-export-and-import-data/

First, pre-preparation

1. telnet to the server in SSH and locate the intermediate file (. DMP) stored in the directory:

/*rmdir/home/oracle/pump_dir--Delete Empty directory */

2. Create a logical directory with Administrator Sys

Create or replace directory Pump_dir as '/home/oracle/pump_dir ';

3. Give user users permission to operate in the specified directory, preferably with administrator authorization such as Sys

Grant Read,write on directory pump_dir to user;

4. View the Management Manager directory

SELECT * from Dba_directories;

/*drop Directory pump_dir;--Delete directories */

II. Export of data

1. Full Library Export

2. User mode export (schemas)

3. Table schema Export (tables)

4. Conditional export (query)

Third, import data

1.

2.

Iv. Introduction of parameters

1.userid: The first parameter of the command line

2.directory: directory where dump files and log files are stored

3.dumpfile: Destination dump file

4.logfile: Log file

5.full: full-Library export

6.content: Specify the data to export, default to all

content={all| data_only| Metadata_only}

All: Export object definition and all data

Data_only: Export only Object data

Metadata_only: Export only object definitions

7.schemas: Specify the execution scheme mode export, default to the current user scenario

8.tables: Specify table Schema Export

9.tablespaces:

Oracle Data Pump Import and export (EXPDP/IMPDP)

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.