Replicat Abends With Error OGG-01816 Partial operations are not supported in this release
(Doc ID 2311802.1)
Last updated on AUGUST 21, 2023
Applies to:
Oracle GoldenGate - Version 11.1.1.0.0 and laterInformation in this document applies to any platform.
Goal
If the source is Oracle db with integrated mode, then extract must use FETCHPARTIALXML, FETCHPARTIALLOB to avoid partial lob/xml updates from appearing in the trail.
FETCHPARTIALLOB
(Oracle) Valid for Extract in integrated capture mode.
Use this option when replicating to a non-Oracle target or in other conditions where the full LOB image is required. It causes Extract to fetch the full LOB object, instead of using the partial change object from the redo record. By default, the database logmining server sends Extract a whole or partial LOB, depending on whether all or part of the source LOB was updated. To ensure the correct snapshot of the LOB, the Oracle Flashback feature must be enabled for the table and Extract must be configured to use it. The Extract FETCHOPTIONS parameter controls fetching and must be set to USESNAPSHOT (the default in the absence of NOUSESNAPSHOT). Without a Flashback snapshot, Extract fetches the LOB from the table, which may be a different image from the point in time when the redo record was generated.
FETCHPARTIALXML
(Oracle) Valid for Extract in integrated capture mode
Use this option when replicating to a non-Oracle target or in other conditions where the full LOB image is required. It causes Extract to fetch the full XML document, instead of using the partial change image from the redo record. By default, the database logmining server sends Extract a whole or partial XML document, depending on whether all or part of the source XML was updated. To ensure the correct snapshot of the XML, the Oracle Flashback feature must be enabled for the table and Extract must be configured to use it. The Extract FETCHOPTIONS parameter controls fetching and must be set to USESNAPSHOT (the default in the absence of NOUSESNAPSHOT). Without a Flashback snapshot, Extract fetches the XML document from the table, which may be a different image from the point in time when the redo record was generated.
Solution
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
Goal |
Solution |