Re: Refresh Snapshot on Oracle 8i Rel. 2

From: Axel Klos <axk_at_fernbach.com>
Date: Fri, 08 Sep 2000 15:10:44 +0200
Message-ID: <39B8E554.87A6393C@fernbach.com>

Hello,

the first part of problem solved myself. Its an Bug in Oracle, when refresh an Snapshot, the SNAP$ base table no not getting updatet (BUG NO 557451).

The autorefresh is not working, what can i do?

Axel

Axel Klos wrote:

> Hello,
>
> i migrate an database from 7.3.4 to 8.1.6. Now i test the snapshots and
> its work after running any repcat scripts. When i refresh an snaphsot
> with dbms_snapshot package i have no errors. Now, when i select
> last_refresh from dba_snaphots i receive not the actual date thats not
> correct. What must i do?
>
> What can i do for an automatic refresh?
>
> Regards
>
> Axel
Received on Fri Sep 08 2000 - 08:10:44 CDT