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;
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