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
CREATE DATABASE LINK DNYTST10.world CONNECT
TO strmadm IDENTIFIED BY strmadm USING 'DNYTST10.world'
/