Set up the Supplemental Logging
-- Unconditional Primary Key only
alter table ny1.allinsured1
add supplemental log data (primary key)
columns ;
The ALL columns option specifies that when
a row is updated, all columns of that row, except for LOBs,
LONGs, and ADTs, are placed in the redo log file. To enable ALL
column logging at the table level for ALLINSURED1, the following
SQL statement should be executed:
-- unconditional ALL columns
ALTER TABLE ny1.allinsured1
ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
The dba_log_groups view can be
queried to verify the supplemental logging setup. The following
SQL statement can be used to query:
SELECT log_group_name, owner, table_name,
DECODE(always, 'ALWAYS', 'Unconditional',
NULL, 'Conditional') ALWAYS
FROM DBA_LOG_GROUPS
/
To drop a conditional or unconditional
supplemental log group, use the DROP SUPPLEMENTAL LOG GROUP
clause in the ALTER TABLE statement. For example, to drop a
supplemental log group named log_grp_allins1, the
following statement should be run:
