Valid For

Extract data pump and Replicat

Description

Use the DECRYPTTRAIL parameter to decrypt data in a trail or extract file. This parameter is required in the following cases:

• If the trail was encrypted with the master key and wallet method, use DECRYPTTRAIL for a data pump only if you want the data to be decrypted when written to the output trail of the data pump. Otherwise, this parameter is not needed. If the data-pump requires further processing of records, it decrypts automatically and then re-encrypts the data before writing it to the output trail. Replicat always decrypts data automatically when the master key and wallet method is used.

• When DECRYPTTRAIL is used for a data pump, use the ENCRYPTTRAIL parameter before specifying any output trails that must be encrypted.

• If the trail was encrypted with the ENCKEYS method, use DECRYPTTRAIL for Replicat to decrypt the data before applying it to the target.

Data encryption is controlled by the ENCRYPTTRAIL | NOENCRYPTTRAIL parameters.

For Oracle, if you are using wallet based encryption DECRYPTTRAIL does not require a cipher because it is recorded in the trail file header.

Default

None

Syntax

DECRYPTTRAIL [{AES128 | AES192 | AES256}]

DECRYPTTRAIL

Valid without any other options only if the trail or file was encrypted with ENCRYPTTRAIL without options to use 256-key byte substitution.

{AES128 | AES192 | AES256}

Valid for master key and wallet method and ENCKEYS method. Specify the same AES cipher that was used in ENCRYPTTRAIL to encrypt the trail or file.

Example

Example 1   

The following is an example of the ENCKEYS method.

DECRYPTTRAIL AES192

Example 2   

The following is all that is needed to decrypt using the master key and wallet method.

DECRYPTTRAIL