Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Supplemental Logging

user11969763Feb 4 2010 — edited Feb 7 2010
For streams, one of the requirements as per the manual is enabling supplemental logging. I have enabled the same at the DB level using:

ALTER DATABASE ADD SUPPLEMENTAL LOG DATA (UNIQUE) COLUMNS;

I want to have a schema to schema (1-to-1) streams replication. Is it also necessary to create an unconditional log group and add each table of the schema to this group again using:

ALTER TABLE EMP1 ADD SUPPLEMENTAL LOG GROUP s_log_grp (emp_unique) ALWAYS;

The schema tables only have unique keys and no primary keys.

Thanks.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 7 2010
Added on Feb 4 2010
2 comments
2,725 views