PK update

[Roshan]

Hello Erman,

normally when supplemental log all columns is enabled for 1 table, all columns are logged in the trail file for any update. However, when I connect a fielwriter to the GGtrail reader on Striim, I see not all columns are present for an update. Below shows only 4 columns out of total 6 columns.


 {
  "metadata":{"TableID":53,"PK_UPDATE":"true","TableName":"CBS_CORE.CB_USER_SESSION","TxnID":"0.10.52.6416297","OperationName":"DELETE","FileName":"cd000017944","FileOffset":15070742,"TimeStamp":"2022-07-29T16:02:05.000+04:00","Oracle ROWID":"AAAjK8AAcAAHMAhAAA","CSN":"421598143483","RecordStatus":"VALID_RECORD"},
  "data":{
"SESSION_ID_V":"270020220729160006",
"LOG_DATE_TIME_D":"2022-07-29T20:00:06.000+04:00",
"LAST_ACCESSED_TIME_D":"2022-07-29T20:00:06.000+04:00",
"APP_SESSION_FLG_V":"B"
},
  "before":{
"SESSION_ID_V":"270020220729160006",
"LOG_DATE_TIME_D":"2022-07-29T20:00:06.000+04:00",
"LAST_ACCESSED_TIME_D":"2022-07-29T20:00:06.000+04:00",
"APP_SESSION_FLG_V":"B"
},
  "userdata":{"op_update_date":"2022-07-29T20:05:35.815+04:00"}
 },

Kindly advise.

Thanks,

[ErmanArslansOracleBlog]

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..

[Roshan]

OK thanks Erman.