Oracle Data Pump Import and export (EXPDP/IMPDP)

--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)