"copy_rows" and DBMS_REPUTIL.FROM

From: <mikea730_at_my-deja.com>
Date: Tue, 19 Dec 2000 05:01:38 GMT
Message-ID: <91mq3g$39e$1@nnrp1.deja.com>

Has anyone noticed that DBMS_REPUTIL.FROM_REMOTE does not resolve to TRUE when using the "copy_rows" option to add a master database. I've got triggers on tables in the new database I'm adding that I don't want to fire if a remote transaction comes in via replication. During "normal" replication the DBMS_REPUTIL.FROM_REMOTE "if" statement works fine and skips the trigger logic, but for some reason when adding a new master database using the copy_rows, the triggers fire. DBMS_REPUTIL.FROM_REMOTE is not returning TRUE when when using "copy_rows".

I'm running Oracle 8.1.5 on Solaris

BEGIN

        DBMS_REPCAT.ADD_MASTER_DATABASE (
                gname => 'MYRES_MG',
                master => 'myres2.itstest1.resonate.com',
                use_existing_objects => TRUE,
                copy_rows => TRUE,
                propagation_mode => 'ASYNCHRONOUS'
        );

END;
/

Sent via Deja.com
http://www.deja.com/ Received on Mon Dec 18 2000 - 23:01:38 CST

"copy_rows" and DBMS_REPUTIL.FROM_REMOTE