Use DECRYPT to decrypt data that was encrypted with trail encryption, so that it can be viewed with Logdump.
Default
OFF
Syntax
DECRYPT {OFF | ON [KEYNAME key_name]}
OFFNo decryption. This is the default.
ON [KEYNAME key_name]ON without the KEYNAME clause decrypts data that was encrypted with the ENCRYPTTRAIL parameter without options (256-key byte substitution).
ON with the KEYNAME clause decrypts data that was encrypted with ENCRYPTTRAIL using an AES algorithm and a KEYNAME clause. For key_name, supply the logical name of the encryption key that was used in the KEYNAME keyname clause of ENCRYPTTRAIL.
For more information about ENCRYPTTRAIL, see Reference for Oracle GoldenGate for Windows and UNIX.
ON also works to decyrpt records that were encrypted using the Oracle wallet and master key methods; similar to how the DECRYPTTRAIL parameter for Replicat or Pump behaves.
Example
DECRYPT ON
Example
DECRYPT ON KEYNAME mykey