GoldenGate 21

https://www.oracle.com/middleware/technologies/goldengate-downloads.html https://www.oracle.com/middleware/technologies/goldengate-downloads.html

Delete Trailfile GoldenGate

Use DELETE EXTTRAIL to delete the record of checkpoints associated with a trail on a local system. Checkpoints are maintained in a file bearing the same name as the group in the dirchk sub-directory of the Oracle GoldenGate directory. This command only deletes references to the specified trail from the checkpoint file. It does not delete the trail files […]

GoldenGate Integrated Cap Dictionary Builds and Logminer

This will explain a little bit about the LogMiner Dictionaries this is something that many folks do not understand when doing integrated capture and this goes into some detail with examples. [table id=2 /] Integrated Capture LogMiner Dictionaries Oracle Doc for Logminer 18c When trying to setup GG extract. When registering an integrated extract, behind […]

Streams Pool Advisor

Use the Streams Pool Advisor for versions under 19c Streams Pool Advisor For versions 19c or higher use the new utl_rpadv Not sure about if this can be used for versions earlier…..will check it out soon this is a much longer line as a test this is a test this is a test this is […]