PURGEOLDEXTRACTS for Extract and Replicat

Valid for

Extract and Replicat

Description

Use PURGEOLDEXTRACTS in an Extract or Replicat parameter file to delete old trail files whenever Oracle GoldenGate starts processing from a new one. Using PURGEOLDEXTRACTS conserves disk space by preventing the accumulation of trail files.

Purging by Extract is appropriate if the process is a data pump. After the data is sent to the target system, the files can be purged. Otherwise, purging would ordinarily be done by Replicat.

Do not use PURGEOLDEXTRACTS in an Extract or Replicat parameter file if more than one Extract or Replicat is reading the same set of trail files. If multiple processes are reading the same files, one process could purge a file before another is finished with it. In this case use PURGEOLDEXTRACTS in the Manager. As a general rule, letting the Manager handle PURGEOLDEXTRACTS is preferred for all Oracle GoldenGate configurations because it provides centralized management of your trail files.

Default

Purge the trail file when moving to the next file in the sequence.

Syntax

PURGEOLDEXTRACTS