CONTEXT_2 is a field which will hold (in XML format) context information regarding all columns and values (except those with domains of VARCHAR2000 & VARCHAR4000) that have had data changed.

When a change takes place, but before the values are committed to the database, a Change Log record is created without the context columns populated. When the changes are committed to the database, the context columns are added to the new Change Log record, and the Change Log Details records are created for every changed column and added to the database.

If logging is turned on for a table and turned off for a changed column, no Change Log Details record will be created.

If there is an exception between the time the Change Log is created and before the Change Log Details and context information are created, then Context 1 will hold a message indicating that auditing was not complete.

---

Notes #

Click to create a new notes page