RE: Replication question

From: John Weatherman <john.weatherman_at_replacements.com>
Date: Thu, 05 Sep 2002 07:38:27 -0800
Message-ID: <F001.004C87C9.20020905073827@fatcity.com>

The jobs are used to propogate the captured transactions. The transactions are captured by the packages called by the internal triggers.

PAX, John P Weatherman
Database Administrator
Replacements Ltd.

-----Original Message-----
Sent: Thursday, September 05, 2002 10:28 AM To: Multiple recipients of list ORACLE-L

Paul - I don't know multimaster replication, so bear with me. I am thumbing through my copy of Oracle Distributed Systems by Charles Dye. Does your question relate to how propagation is controlled? I think propagation is controlled by scheduled jobs. Take a look at the procedure DBMS_DEFER_SYS.SCHEDULE_PUSH, which the book says "Schedules an automatic push of the deftran queue to the specified master database". Hope this helps, it may irritate someone that really knows the answer to your question into replying.
Dennis Williams
DBA
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Wednesday, September 04, 2002 8:04 PM To: Multiple recipients of list ORACLE-L

When DBMS_REPCAT.GENERATE_REPLICATION_SUPPORT is executed to build the necessary underpinnings for multimaster replication of an object, it creates a package called <object_name>$RP. This package contains code to be run when rows are inserted, updated, or deleted. There are, however, no trigges in the owning schema, nor in that of the replication administrator. What, then, is the mechanism by which the procedures in this package are called?

TIA!

---

Paul Baumgartel, Adept Computer Associates, Inc. paul.baumgartel_at_aya.yale.edu

---

Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Paul Baumgartel
  INET: treegarden_at_yahoo.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: DENNIS WILLIAMS
  INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: John Weatherman
  INET: john.weatherman_at_replacements.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Thu Sep 05 2002 - 10:38:27 CDT