Re: can't refresh snapshot

Anja:

What both of us missed were the init.ora parameters that have to be set for the automatic snapshot refresh process to be enabled. I too had all the snapshot details set up, and I could refresh manually, but the automatic refresh would never kick in! The init.ora parameters required are described in the manual that Dany has indicated.

Dinesh

Anja Mindermann
(anja_at_next08.megatel.de)
wrote: : 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 ?

: A. Mindermann
Received on Thu Feb 22 1996 - 00:00:00 CET