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.
See Administering Oracle GoldenGate for more information about trail or file encryption.
Default
None
Syntax
DECRYPTTRAIL [{AES128 | AES192 | AES256}]
DECRYPTTRAILValid 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.