1.48 DECRYPTTRAIL
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 theENCRYPTTRAIL
parameter before specifying any output trails that must be encrypted. -
If the trail was encrypted with the
ENCKEYS
method, useDECRYPTTRAIL
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 inENCRYPTTRAIL
to encrypt the trail or file.
Parent topic: Oracle GoldenGate Parameters