Author Topic: Data Pump Enhancements in Oracle Database 11g Release 1  (Read 3184 times)

Mike

  • Administrator
  • Hero Member
  • *****
  • Posts: 2025
    • View Profile
Data Pump Enhancements in Oracle Database 11g Release 1
« on: March 23, 2009, 06:22:08 AM »
Full Article: Data Pump Enhancements in Oracle Database 11g Release 1

Data Pump Enhancements in Oracle Database 11g Release 1


This article provides an overview of the main Data Pump enhancements in Oracle Database 11g Release 1, including:

    * COMPRESSION
    * Encryption Parameters
          o ENCRYPTION and ENCRYPTION_PASSWORD
          o ENCRYPTION_ALGORITHM
          o ENCRYPTION_MODE
    * TRANSPORTABLE
    * PARTITION_OPTIONS
    * REUSE_DUMPFILES
    * REMAP_TABLE
    * DATA_OPTIONS
          o SKIP_CONSTRAINT_ERRORS
          o XML_CLOBS
    * REMAP_DATA
    * Miscellaneous Enhancements

COMPRESSION
The COMPRESSION parameter allows you to decide what, if anything, you wish to compress in your export. The syntax is shown below.

    COMPRESSION={ALL | DATA_ONLY | METADATA_ONLY | NONE}

The available options are:

    * ALL: Both metadata and data are compressed.
    * DATA_ONLY: Only data is compressed.
    * METADATA_ONLY: Only metadata is compressed. This is the default setting.
    * NONE: Nothing is compressed.

Here is an example of the COMPRESSION parameter being used.

    expdp test/test schemas=TEST directory=TEST_DIR dumpfile=TEST.dmp logfile=expdpTEST.log
      compression=all

The COMPATIBLE initialization parameter should be set to "11.0.0" or higher to use these options, except for the METADATA_ONLY option, which is available with a COMPATIBLE setting of "10.2".

Encryption Parameters
Data pump encryption is an Enterprise Edition feature, so the parameters described below are only relevant for Enterprise Edition installations. In addition, the COMPATIBLE initialisation parameter must be set to "11.0.0" or higher to use these features.


Full Article: Data Pump Enhancements in Oracle Database 11g Release 1