Re: can't refresh snapshot

Norm LeBlanc wrote:
>
> Lawrence James (james.lawrence_at_epamail.epa.gov) wrote:
> : In article <4ffpm1$me7_at_crissy.ge.com> Donna Kray <kray.donna_at_mlink.motors.ge.com> writes:
> : >From: Donna Kray <kray.donna_at_mlink.motors.ge.com>
> : >Subject: Re: can't refresh snapshot
> : >Date: 9 Feb 1996 15:36:33 GMT
 

> : >rjh_at_qdot.qld.gov.au (Robert Howlett) wrote:
> : >>In article <4e65h4$a5t_at_sam.inforamp.net>,
> : >> chicnorm_at_norm.inforamp.net (Norm LeBlanc) wrote:
> : >>>I am running Oracle 7.0 with the procedural and distributed options. I can
> : >>>create snapshots and refresh them manually but cannot do this automatically.
> : >>>I cannot find any documentation for the initora setting mentioned below.
> : >>>The database is running on a SCO unix platform and there is a program
> : >>>called 'refsnap' but again there is no documentation for it.
> : >>
 

> : Does the database link have a username and password in it? If not the manual
> : refresh will work but the automatic will not.
 

> : Lawrence.....
>
> Yes, the database link does have a name and password. My problem was that
> I didn't know about the init.ora parameters that have to be set for
> automatic snapshot refreshes to occur.
>
> Thanks,
> Dinesh

dear Dinesh!

 1st ! all the answers are in Oracle7 server distributed systems

        replicated data book (PART # A21903-2).

 2en you must create the snapshot with :

        create snapshot...
           pct ... 
           tablespace...
           storage ....
   (and than  !!!)
         REFRESH FAST
         START WITH sysdate
         NEXT  sysdate+7           <-----  for example
       i.e 7 days after the last refresh time

                             bye   strmis_at_actcom.co.il (DANY).