Wednesday, June 22, 2011

How to enable supplement logging at table or column level?

ALTER TABLE tab1 ADD SUPPLEMENTAL LOG GROUP tab1_grp1 (col1,col2) ALWAYS;
ALTER TABLE tab1 DROP SUPPLEMENTAL LOG GROUP tab1_grp1;

ALTER TABLE tab1 ADD SUPPLEMENTAL LOG DATA (ALL) COLUMNS;
ALTER TABLE tab1 DROP SUPPLEMENTAL LOG DATA (ALL) COLUMNS;

ALTER TABLE tab1 ADD SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;
ALTER TABLE tab1 DROP SUPPLEMENTAL LOG DATA (PRIMARY KEY) COLUMNS;

ALTER TABLE tab1 ADD SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;
ALTER TABLE tab1 DROP SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;

ALTER TABLE tab1 ADD SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;
ALTER TABLE tab1 DROP SUPPLEMENTAL LOG DATA (FOREIGN KEY) COLUMNS;

No comments:

Post a Comment