Page Comparison

• For Oracle 10g, 11g if there is no primary key defined on the table, then Oracle automatically adds additional columns to the supplemental log data to satisfy either the unique key, or if there is no unique key, then it adds all the columns in the table.

• For Oracle 9i, Oracle does not automatically adds additional columns. The specific supplemental log level has to be defined. Dbvisit Replicate does this automatically.

In Oracle 9i, there is a limit of 33 columns in each supplemental log group. See support.oracle.com note ID 466439.1

So in the case of a table with more than 33 columns you create as many distinct supplemental log groups as required for the same table, e.g., 

ALTER TABLE <table_name> ADD SUPPLEMENTAL LOG GROUP <log_grp1> 
(Column1,....,Column33) ALWAYS; 

ALTER TABLE <table_name> ADD SUPPLEMENTAL LOG GROUP <log_grp2> 
(Column34,....,Column66) ALWAYS; 
 
ALTER TABLE <table_name> ADD SUPPLEMENTAL LOG GROUP <log_grp3> 
(Column67,....,Column99) ALWAYS;