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

On Fri, 22 Nov 2002 18:00:31 +0000, buckeye234 <member_at_dbforums.com> wrote:

>
>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

Other than that each 5 secs does appear to be a bit often. I won't be surprised when the dbms_jobs mechanism won't be able to handle this, especially if job_queue_interval is greater than those 5 seconds. I think the OP should reconsider, or implement replication by means of triggers.

Regards

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Fri Nov 22 2002 - 14:19:55 CST