Page Comparison

...

The following SQL is run by Dbvisit Replicate to turn on supplemental logging:

SQL> alter database add supplemental log data; 

If

...

DDL

...

is

...

enabled,

...

then

...

the

...

following

...

is

...

run

...

SQL> alter database add supplemental log data (primary key) columns;

For

...

each

...

table

...

to

...

be

...

replicated

...

the

...

following

...

SQL

...

is

...

run

SQL> alter table '||owner||'.'||table_name||' add supplemental log data (primary key) columns; 

To

...

check

...

and

...

monitor

...

what

...

supplemental

...

logging

...

has

...

been

...

turned

...

on,

...

the

...

following

...

query

...

can

...

be

...

run

...

SQL> SELECT supplemental_log_data_min MIN, supplemental_log_data_pk PK, supplemental_log_data_ui UI, supplemental_log_data_fk FK,supplemental_log_data_all "ALL" FROM 

v$database;