Oracle10g and later export/Import (DatapumpExport/Import) Tool

Datapump is a service that replaces the old importexport tool based on the structure of mass data migration. The old importexport tool is still available, but not supported

Datapump is a service that replaces the old import/export tool based on the structure of large data migration. The old import/export tool is still available, but not supported

Datapump is a service that replaces the old import/export tool based on the structure of large data migration. The old import/export tool is still available, but does not support all Oracle 10g and 11g features. The new tool is named expdp and impdp.

Content

This document describes how to export/import Oracle 10g and later versions:

Start using datapump for export

Create Database directory

Try exporting again

Import another database

Network Import

Call from PL/SQL

Oracle 11g Release 1 (11.1) Data Pump export and import Overview

Oracle 11g Release 1 (11.1) Data Pump export and import Mode

References

Modify record

Start exporting with datapump

$ Expdp scott/tiger DIRECTORY = dmpdir DUMPFILE = scott. dmp Export: Release 10.2.0.1.0-64bit Production the logFile. ORA-39087: directory name DMPDIRIsInvalid

Note:

"Dmpdir" is the export directory;

"Scott. dmp" is the exported datadump file;

The tables under scott are in the default tablespace USERS and temporary tablespace TEMP. So this command exports scott's table (object;

Because Oracle already has these two tablespaces, you can directly import them. However, if you create a tablespace, you must first create the tablespace and then import it.

Export failed! Because, we need to create a directory first!

Create Database directory

Run the following command to create a database export directory. This directory must point to a valid directory of the same server as the database:

,Write ONDIRECTORY dmpdirTOScott;GrantSucceeded.

Note:

"Dmpdir" is the export directory, "/opt/oracle" is the database path (you can also use the absolute path of the operating system, such as "d: \ db_backup ");

Export directory authorization. Allow scott users to read and write the directory. In this way, scott can access the directory normally and store the database content and exported log files here.

Note: Oracle introduced a default directory named "DATA_PUMP_DIR" from Oracle 10g R2, as shown below:

SQL>SELECTDirectory_pathFROMDba_directoriesWHEREDirectory_name ='Data _ PUMP_DIR'; DIRECTORY_PATH ----------------------------------------------------------------------------------/app/oracle/product/10.2.0/rdbms/log/

Try exporting again

$ Expdp scott/tiger DIRECTORY = dmpdir DUMPFILE = scott. dmp Export: Release 10.2.0.1.0-64bit Production SCOTT. SYS_EXPORT_SCHEMA_01Is:/App/oracle/scott. dmpJob "SCOTT". "SYS_EXPORT_SCHEMA_01" successfully completedAt11:44:50