Handling Extract Errors
There is no specific parameter to handle Extract errors when DML operations are being extracted, but Extract does provide a number of parameters that can be used to prevent anticipated problems. These parameters handle anomalies that can occur during the processing of DML operations, such as what to do when a row to be fetched cannot be located, or what to do when the transaction log is not available. The following is a partial list of these parameters.
-
FETCHOPTIONS
-
WARNLONGTRANS
-
DBOPTIONS
-
TRANLOGOPTIONS
To handle extraction errors that relate to DDL operations, use the DDLERROR
parameter.
For a complete parameter list, see Reference for Oracle GoldenGate.