Err: Creating Replication Support

From: Phil Melendez <pme_at_cts.com>
Date: 1997/02/08
Message-ID: <5dii2f$l9k_at_bogus.cts.com>#1/1

All,

I am connsistantly running into the following error (shown below). I called Oracle Support and they mentioned to rerun the catrep.sql script. I have but still get the same error, has anyone seen this before? It looks to me that when I generate replication support a row-level trigger is created. Then when I try and create a snapshot log on the replicated table it trys to create another trigger on the table, but it always fails. Any ideas on how to make this work?

Thanks,

Phil M.

• Log of Replication **********

comex> DROP SNAPSHOT LOG ON AR.AR_TRN
  2 /

Snapshot log dropped.

comex> EXECUTE DBMS_REPCAT.CREATE_MASTER_REPGROUP('AR_REP_GRP', 'Created on ' ||
 SYSDATE ) PL/SQL procedure successfully completed.

comex> EXECUTE DBMS_REPCAT.CREATE_MASTER_REPOBJECT('AR', 'AR_TRN',
'table', TRUE

, NULL,'Created on ' || SYSDATE , FALSE, TRUE, 'AR_REP_GRP' )

PL/SQL procedure successfully completed.

comex> EXECUTE DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT('AR', 'AR_TRN',
'table'

)

PL/SQL procedure successfully completed.

comex> CREATE SNAPSHOT LOG ON AR.AR_TRN
  2 /
CREATE SNAPSHOT LOG ON AR.AR_TRN
*
ERROR at line 1:
ORA-04090: 'TLOG$_AR_TRN' specifies same table, event and trigger time as
'AR_TRN$RT'
******Objects in dba_repobjects***********

Sname Oname type STATUS ID Cmnt ---------- --------------- ---------- --------- ------- --------------- Gname

---

AR AR_TRN$RP PACKAGE VALID 6028 SYSTEM-GENERATE AR_REP_GRP AR AR_TRN$RP PACKAGE BO VALID 6253 SYSTEM-GENERATE AR_REP_GRP AR AR_TRN$RR PACKAGE VALID 6029 SYSTEM-GENERATE AR_REP_GRP AR AR_TRN$RR PACKAGE BO VALID 6252 SYSTEM-GENERATE AR_REP_GRP AR AR_TRN$RT TRIGGER ERROR 6254 SYSTEM-GENERATE AR_REP_GRP AR AR_TRN TABLE VALID 5434 Created on 08-F AR_REP_GRP Received on Sat Feb 08 1997 - 00:00:00 CET