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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
