1. Oracle GoldenGate Classic Documentation
  2. Administer
  3. Error Management
  4. Automatic Conflict Detection and Resolution
  5. Managing Automatic Conflict Detection and Resolution
  6. Purging Tombstone Rows

Purging Tombstone Rows

The PURGE_TOMBSTONES procedure removes tombstone rows that were recorded before a specified date and time. This procedure removes the tombstone rows for all tables configured for conflict resolution in the database.
It might be necessary to purge tombstone rows periodically to keep the tombstone log from growing too large over time.
  1. Connect to the inbound server database as an Oracle GoldenGate administrator.
  2. Run the PURGE_TOMBSTONES procedure and specify the date and time.

Example 8-14 Purging Tombstone Rows

This example purges all tombstone rows recorded before 3:00 p.m. on December, 1, 2015 Eastern Standard Time. The timestamp must be entered in TIMESTAMP WITH TIME ZONE format. 

EXEC DBMS_GOLDENGATE_ADM.PURGE_TOMBSTONES('2015-12-01 15:00:00.000000 EST');