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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Refreshing materialized viws

Re: Refreshing materialized viws

From: Frank van Bortel <fvanbortel_at_netscape.net>
Date: Thu, 03 Mar 2005 14:27:56 +0100
Message-ID: <d0738e$r3f$1@news2.zwoll1.ov.home.nl>


leszek wrote:

>>Why do you want it stopped, anyway - is that a backup window?

>
>
> yes it is for that
>
>
>>If so, you will end up with a bunch of failed jobs, that can be
>>cleared easily - replication will continue after 5 AM

>
>
> amount of max failed job is 16
> How can I increase this parameter ?? in startup parameter list I don't see
> something like max_failed_jobs
>
>

Stop replication?
You did not state your version, but up to and including V9iR2, you can use the
dbms_repcat.suspend_master_activity
at the master site.

For more - see http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage

-- 
Regards,
Frank van Bortel
Received on Thu Mar 03 2005 - 07:27:56 CST

Original text of this message

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