What is Data Pump in Oracle 11g

In This tutorial i'll be show you how to manage data pump and as well as how many way to many it in oracle 11g R2

  This is server-based facility to manage high speed data and mata-data in oracle database.
  This datapump infrastructure is callable via DBMS_DATAPUMP in PL/SQL package.
  Oracle 11g database provide two tools as below,

•  Through command line.
• EXPDP
• IMPDP
•  Through web based called grid infrastructure.

  The oracle data pump have many benefits and some new features as below,

1. Data selection and Fine-grained.
2. Parallel execution.
3. Explicit specification of database version.
4. Network mode in distributed environment.
5. Estimation of export job space consumption.
6. Remapping capabilities.
7. Compression of data during a data pump export.
8. Data and Metadata compression.
9. Ability to export XML type data as CLOB.
10. Legacy mode to support old import and export files. 

  The EXCLUDE, INCLUDE and CONTENT parameter are used for fine grained object and data selection.

  You can specify the database version for objects to be moved [ through VERSION parameter ]
to create dump file set that is compatible with a previous release oracle database.

  You can use the PARALLEL parameter to specify the maximum number of active execution server operating on behalf of export job.

  Network mode enables you to export from a remote database directly to a dump file set. This can be done only by using database link.

  You can estimated how much space an export job would be consume by using ESTIMATE_ONLY
parameter.

  During import, you can directly change the target data file names, tablespaces, schemas.

 You can use the COMPRESSION parameter to indicate whether the metadata should be compressed in export dump file so that is consumes less desk space. If you compress the metadata, it is automatically uncompressed during import.

In oracle database 11g, new features as below,

1. compress both data and metadata or only data or only metadata during export.
1. you can encrypt bot data and metadata or only data or only metadata  during export.
2. you can also use specific encryption algorithm for an export.
3. you can specify the type of security to use for performing encryption and decryption
2. Perform on table mode export and import using transportable method.
3. Rename tables during an import operation.
4. Remap data as it is being imported into a new database
5. Legacy mode to support the use of original Export and Import scripts.

That's are the exploration of Data Pumps in Oracle 11g R2