Re: can't refresh snapshot

From: Anja Mindermann <anja_at_next08.megatel.de>
Date: 1996/02/20
Message-ID: <1996Feb20.102116.11230_at_megatel.de>#1/1

In article <312846FD.61CF_at_actcom.co.il> GARABAGI DANI <strmis_at_actcom.co.il> writes:
> 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
>
>
>
> 3ed you must create the a snapshot log table on the mater table
> uning : "create snapshot log on (table_name)
> tablespace (tablespace_name) storage ....etc.
>
> 4th you may use also refresh goups and relate this table to the group
>
>
> bye strmis_at_actcom.co.il (DANY).

>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>..

I try these steps, but a refresh dit not happend. Does anybody knows, at which time the refresh is starting, and if it is possible to do a refresh every hour ?

1. Mindermann

Received on Tue Feb 20 1996 - 00:00:00 CET