Purging the tables that are being replicated via GoldenGate
edited Mar 12, 2014 12:00PM in GoldenGate, Streams and Distributed Database (MOSC) 3 commentsAnswered
Hi,
We are planning to purge the set of the tables that are being replicated via GoldenGate and deletes on those tables are not being replicated and only inserts are being replicated. We are following below method to purge the tables.. So we are wondering what would be the best procedure to handle both the capture and apply during the purge process. You early response is very much appreciated.
1. Rename the table A to table B
2. Create table A
3. Insert in to table A select * from table B where <purging criteria>
Extract parameter file: -- Capture everything..
TFAADM.TWFA0350_FR_QUEUE_TRKG
0