Re: Problem with automatic snapshot refreshes

From: <hieuvng_at_yahoo.com>
Date: Wed, 30 Sep 1998 02:55:55 GMT
Message-ID: <6us6jr$cq$1@nnrp1.dejanews.com>

You should set snapshot_refresh_processes in =2 (the values is in [2..10]), it will auto

In article <6uq5s5$icm$1_at_nnrp1.dejanews.com>, Silvia_Pirpamer_at_sonymusic.com wrote:
> We have two databases (DB-A - oracle 7.2.3 on AIX-IBM-RS6000- and DB-B-
> oracle 7.3.4.1.0 on SunSolaris). I created snapshots on the DB-A. The master
> table and its log_table is in DB-B. The init.ora-parameters in the DB-A are:
> snapshot_refresh_processes=1 snapshot_refresh_interval=600
> snapshot_refresh_keep_connections=FALSE
>
> The log-tables exist in the DB-B and have entries.
> The snapshot-user on DB-A has a private db-link to DB-B.
> The refreshing rate is every week at the same time.
>
> But the snapshots are not refreshed.
> The manual refresh works well, but automatic refresh doesn't work.
>
> Can someone help me with this problem?
>
> Thanks
>
> Silvia
>
> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum Received on Tue Sep 29 1998 - 21:55:55 CDT