Oracle-L: Multimaster Replication Doubt...

From: Rahul Dandekar <rvd_oracle_at_hotmail.com>
Date: Mon, 04 Mar 2002 09:39:03 -0800
Message-ID: <F001.0041E673.20020304093903@fatcity.com>

1.
It is my understanding that Oracle 7.x has continuous purge of the propogated deftrans. There is no option of scheduling periodic purge at specific time. Am I correct?

2.
How to schedule continuous purge of propogated deftrans in Oracle 8i from command line?

prompt **************** SCHEDULE PURGE AT MASTER SITE ********************

BEGIN
DBMS_DEFER_SYS.SCHEDULE_PURGE (
NEXT_DATE => SYSDATE,
INTERVAL => 'SYSDATE + 1/24',
DELAY_SECONDS => 0,
ROLLBACK_SEGMENT => '');
END;
/

Manual says set DELAY_SECONDS to 500,000 and set INTERVAL to a value less than
DELAY_SECONDS. I could not understand exactly how this works...

+Rahul

      ___           ___        ___           ___           ___
     /  /\         /  /\      /  /\         /  /\         /  /\
    /  /::\       /  /::\    /  /:/        /  /:/        /  /:/
   /  /:/\:\     /  /:/:|   /  /:/        /  /:/        /  /:/
  /  /::\ \:\   /  /:/|:|  /  /::\  __   /  /:/  ___   /  /:/
 /__/:/\:\_\:\ /__/::\|:| /__/:/\:\/ /\ /__/:/  /  /\ /__/:/
 \__\/~|::\/:/ \__\/\:\:| \__\/  \:\/:/ \  \:\ /  /:/ \  \:\
    |  |:|::/     \__\::|      \__\::/   \  \:\  /:/   \  \:\
    |  |:|\/       |  |:|      /  /:/     \  \:\/:/     \  \:\
    |__|:|         |__|:|     /__/:/       \  \::/       \  \:\
     \__\|          \__\|     \__\/         \__\/         \__\/

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Rahul Dandekar
  INET: rvd_oracle_at_hotmail.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 Mon Mar 04 2002 - 11:39:03 CST