Oracle GoldenGate Error Messages

OGG-25338

The workaround for the Teradata's deferred LOB issue is enabled and might have an impact on the performance.


Cause

Teradata database returns "deferred lob is used more than once" when replicat attempts to set a LOB column to NULL as part of an ALL-AMP UPDATE operation. The DBOPTIONS parameter _ENABLEDEFERREDLOBWORKAROUND enables a workaround that assigns an inline NULL value to the LOB columns instead of using parameterized query.


Action

The DBOPTIONS parameter _ENABLEDEFERREDLOBWORKAROUND might have an impact on the performance. If the LOB column(s) are never intended to be SET to NULL, then this parameter should not be used.