By default, a Replicat process ABENDS when the data being modified doesn’t exist in the target database. Learn how to troubleshoot Oracle GoldenGate Using Exception Handler mechanism, identify if there are any missing prequisites commands like “add trandata” on the source. When this happens you need to troubleshoot the issue and correct it before the […]
Use DBMS_PARALLEL_EXECUTE to divide one huge task into multiple small tasks that can be executed at the same time. See how many ways are there to divide.