Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Multi-master replication in 9i - updates aren't automatically propagating--HELP!
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.comReceived on Fri Nov 22 2002 - 12:00:31 CST