Set up the Supplemental Logging
ALTER TABLE ny1.allinsured1 DROP
SUPPLEMENTAL LOG GROUP log_grp_allins1
/
When does the supplemental log group get
dropped? It gets dropped when the DBA decides to cease
replication for a table. At that point, the DBA may even want
to remove the additional logging for that table, so that
unnecessary extra values are not created into the redo log.
Creating the Database Links
The next step would be to create the
database links. In order to propagate events from a source queue
at a database to a destination queue at another database, a
private database link must be created between the database
containing the source queue and the database containing the
destination queue.
In the following example, a database link
will be created from the STRMADM schema of the source database
of DNYTST10 to the destination schema of STRMADM of DNYOIP20 and
vice-versa.
-- At source database, creater the DB link
CONNECT strmadm/strmadm@DNYTST10.world
CREATE DATABASE LINK DNYOIP20.world CONNECT
TO strmadm IDENTIFIED BY
strmadm USING 'DNYOIP20.world'
/
-- At Target Database, create database link
CONNECT strmadm/strmadm@DNYOIP20.world
