The type of change made to the database: INSERT, UPDATE, DELETE, or DDL (OPERATION column).
The SCN at which a change was made (
SCN column).The SCN at which a change was committed (COMMIT_SCN column).
The transaction to which a change belongs (
XIDUSN, XIDSLT, and XIDSQN columns).The table and schema name of the modified object (SEG_NAME and SEG_OWNER columns).
The name of the user who issued the DDL or DML statement to make the change (
USERNAME column).If the change was due to a SQL DML statement, the reconstructed SQL statements showing SQL DML that is equivalent (but not necessarily identical) to the SQL DML used to generate the redo records (SQL_REDO column).
If a password is part of the statement in a
SQL_REDO column, the password is encrypted. SQL_REDO column values that correspond to DDL statements are always identical to the SQL DDL used to generate the redo records.If the change was due to a SQL DML change, the reconstructed SQL statements showing the SQL DML statements needed to undo the change (SQL_UNDO column).
