Re: PK update

Posted by ErmanArslansOracleBlog on Aug 01, 2022; 2:17pm
URL: http://erman-arslan-s-oracle-forum.124.s1.nabble.com/PK-update-tp11001p11002.html

Hi,

You used LOGALLSUPCOLS parameter right?

Fact:
-------
LOGALLSUPCOLS causes Extract to do the following with these supplementally logged columns:
Automatically includes in the trail record the before image for UPDATE operations.
Automatically includes in the trail record the before image of all supplementally logged columns for both UPDATE and DELETE operations.

Another Fact*:
--------
Certain columns cannot be part of supplemental logging in Oracle. If you want those columns to be present in the trail file, even if they did not change, you must use FETCHOPTIONS MISSINGCOLS in the Extract parameter file.

Also ensure that those trail records were generated, after you enabled the LOGALLSUPCOLS parameter..