Hello,
GETBEFORECOLS / GETUPDATEBEFORES / LOGALLSUPCOLS are all ways of logging the before image to the trail file. Which means the before image is available in the redo and its read from there and logged to the trail file. But does anything need to be done on the RDBMS to make the Oracle database log the before image to redo? Or is it that the database always (by default) logs the before image to redo?
for e.g. we are only doing ADD SCHEMATRANDATA. And we see that the before image is available in the trail files. Which means that the before image was logged to redo too.
Thanks