Oracle Data Pump (expdp and impdp)

 

Oracle data pump is new version of imp and exp utilities. It is faster and flexible to the imp and exp utilities used in previous Oracle versions. 

This article was originally written against Oracle 10g, but the information is still relevant up to and including the latest versions of Oracle.

Create database directory

First of all you have to create directory because Data Pump is a server-based technology, so it deals with directory objects pointing to physical directories on the database server where to keep the database backup.

Granting Read / Write directory privileges to Users

 

Database Export / Import

The FULL parameter indicates that a complete database export is required. The following is an example of the full database export and import syntax.

 

Schema Export / Import

The “schemas” parameter is used to specify the schemas that are to be exported.

 

Table Export / Import

The “tables” parameter is used to specify the tables that are to be exported. You can take backup of single or multiple tables with one command.

 

Include and Exclude

The INCLUDE and EXCLUDE parameters can be used to limit the export/import to specific objects. When the INCLUDE parameter is used, only those objects specified by it will be included in the export/import. When the EXCLUDE parameter is used, all objects except those specified by it will be included in the export/import. The two parameters are mutually exclusive, so use the parameter that requires the least entries to give you the result you require. The basic syntax for both parameters is the same.

Have a good day

Fatima Hussain
Author: Fatima Hussain

Leave a Reply

Your email address will not be published. Required fields are marked *