Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-master replication in 9i - updates aren't automatically propagating--HELP!

Re: Multi-master replication in 9i - updates aren't automatically propagating--HELP!

From: buckeye234 <member_at_dbforums.com>
Date: Fri, 22 Nov 2002 18:00:31 +0000
Message-ID: <2077774.1037988031@dbforums.com>

Look at the next_date and next_sec columns, in the dba_jobs table, for the push job. See if the value is within 5 seconds of the actual time. If it is for sometime o\in the past, I'll bet the problem is in your interval value.

When you submit the interval, you need to have the value enclosed in single quotes ('), otherwise it interprets 'sysdate' as the current date/time. For example, the syntax you posted should be:   '(sysdate + 5/(60*60*24))' and the interval column should look exactly   the same. If you omit the single quotes, the value in the interval   column will have an actual date, and not 'sysdate'.

HTH,
Patrick

--
Posted via http://dbforums.com
Received on Fri Nov 22 2002 - 12:00:31 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US