Data Pump enhancements in Oracle 11g R1 (1)

BKJIA quick translation]

This article gives a brief overview of Data Pump enhancements in Oracle Database 11g R1, including the following:

◆ COMPRESSION)

◆ Encryption parameters

A. ENCRYPTION and ENCRYPTION passwords ENCRYPTION and ENCRYPTION_PASSWORD)

B. Encryption Algorithm ENCRYPTION_ALGORITHM)

C. encryption mode ENCRYPTION_MODE)

◆ Transmit TRANSPORTABLE)

◆ Partition option PARTITION_OPTIONS)

◆ Reuse the dump file REUSE_DUMPFILES)

◆ Re ing REMAP_TABLE)

◆ Data options DATA_OPTIONS)

A. Skip the constraint error SKIP_CONSTRAINT_ERRORS)

B. XML CLOB

◆ Re ing data REMAP_DATA)

◆ Other enhancements

Compression

The COMPRESSION parameter allows you to determine what to compress during export. The syntax is as follows:

COMPRESSION={ALL | DATA_ONLY | METADATA_ONLY | NONE}

Available options include:

◆ ALL metadata and data are compressed

◆ DATA_ONLY only compresses data

◆ METADATA_ONLY only compresses metadata

◆ NONE do not compress

The following is an example of using the COMPRESSION parameter:

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

If you want to use these options, the initialization parameter COMPATIBLE should be set to 11.0.0 or higher, but the METADATA_ONLY option can be used for 10.2.

Encryption Parameters

Data Pump encryption is a feature of the Enterprise Edition, so the content described below is only related to the Enterprise Edition. In addition, the initialization parameter COMPATIBLE should be set to 11.0.0 or higher.

1. ENCRYPTION and ENCRYPTION_PASSWORD

ENCRYPTION is controlled by the ENCRYPTION and ENCRYPTION_PASSWORD parameters. The ENCRYPTION parameter syntax is as follows:

ENCRYPTION = {ALL | DATA_ONLY | ENCRYPTED_COLUMNS_ONLY | METADATA_ONLY | NONE}

Available options include:

◆ ALL metadata and data are encrypted

◆ DATA_ONLY only encrypts data

◆ ENCRYPTED_COLUMNS_ONLY only encrypts columns written to the dump file

◆ METADATA_ONLY only encrypts metadata

◆ NONE not encrypted

If neither the ENCRYPTION parameter nor the ENCRYPTION_PASSWORD parameter is set, the ENCRYPTION level may be NONE. If only the ENCRYPTION_PASSWORD parameter is set, the required parameter may be ALL, the following is an example of using these parameters:

expdp test/test schemas=TEST directory=TEST_DIR dumpfile=TEST.dmp logfile=expdpTEST.log encryption=all encryption_password=password

2. ENCRYPTION_ALGORITHM

The ENCRYPTION_ALGORITHM parameter specifies the encryption algorithm used for export. The default value is "AES128". The syntax is as follows:

ENCRYPTION_ALGORITHM = { AES128 | AES192 | AES256 }

The ENCRYPTION_ALGORITHM parameter must be used together with the ENCRYPTION or ENCRYPTION_PASSWORD parameter, for example:

expdp test/test schemas=TEST directory=TEST_DIR dumpfile=TEST.dmp logfile=expdpTEST.log encryption=all encryption_password=password encryption_algorithm=AES256

3. ENCRYPTION_MODE

The ENCRYPTION_MODE parameter specifies the Security type used during the export or import process. The syntax is as follows:

ENCRYPTION_MODE = { DUAL | PASSWORD | TRANSPARENT }

The valid values and their default settings are described as follows:

◆ In DUAL mode, the exported dump file can be imported using an Oracle encrypted wallet, or the ENCRYPTION_PASSWORD parameter is used during export. If the ENCRYPTION_PASSWORD parameter is set and there is an opened wallet, this is the default setting.

◆ Files exported in PASSWORD mode can be imported only when the ENCRYPTION_PASSWORD parameter is used during export. If the ENCRYPTION_PASSWORD parameter is set but no wallet is opened, This is the default setting.

◆ In TRANSPARENT mode, the encrypted dump file created by the Oracle ENCRYPTION wallet is used. If the ENCRYPTION_PASSWORD parameter is specified in this mode and an error occurs, if only the ENCRYPTION parameter is set, this is the default setting.

For more information about how to configure the wallet, see http://www.oracle-base.com/articles/11g/tablespaceencryption_11gr1.php?wallet_creation.

The ENCRYPTION_MODE parameter must be set to ENCRYPTION or ENCRYPTION_PASSWORD.

expdp test/test schemas=TEST directory=TEST_DIR dumpfile=TEST.dmp logfile=expdpTEST.log encryption=all encryption_password=password encryption_mode=password