Re: stopping a replication

From: Patrick <buckeye234_at_excite.com>
Date: 28 Jun 2001 07:49:54 -0700
Message-ID: <3bbfc440.0106280649.2906b11f@posting.google.com>

daud11_at_hotmail.com (Daud) wrote in message news:<f0bf3cc3.0106271839.699fad73_at_posting.google.com>...
> Hi
>
> I have got a simple snapshot replication going.
> Now, how do I temporarily stop it so that I can shutdown one database.
>
> rgds
> Daud

There is a job that causes the snapshot to refresh. It can be found in the dba_jobs, or user_jobs, view. Use 'execute dbms_job.broken(job_num, TRUE)' to mark the job as broken. This will preserve the data in the snapshot. Once you have restarted the source database, use 'execute dbms_job.broken(job_num, FALSE)' to mark the job as NOT broken. It should then start refrshing the snapshot.

HTH,
Patrick Received on Thu Jun 28 2001 - 09:49:54 CDT