Re: Snapshot problem with fast refresh

From: Alberto Rivera <usfmd2ya_at_ibmmail.com>
Date: 1996/10/01
Message-ID: <52r9qa$qn9_at_eccdb1.pms.ford.com>#1/1

In article <32507BC6.7DE7_at_cadvision.com>, lintonw_at_cadvision.com says...
>
>Are your snapshot 'JOBS' okay? ie are your snapshots 'broken'? I'm
>making some assumptions about what version of ORACLE7 you are using, but
>you might have to start the snap 'JOBS' on the receiving end via the
>DBMS_JOBS.run(job#) package. If the jobs are broken, then you can do a
>'C' refresh, but not fast. Check this out.
>
>Wayne Linton

I'm working with Oracle7 version 7.0.15 on AIX 3.2.5 I set the init.ora parameters in order to maintain snapshots:

   SNAPSHOT_REFRESH_PROCESSES=1    (creates SNP0 background process)
   SNAPSHOT_REFRESH_INTERVAL = 60  (default)
   SNAPSHOT_REFRESH_KEEP_CONNECTIONS = FALSE  (default)

Automatic complete refresh (with a background process) is working fine, but when I change then snapshot refresh option in order to refresh fast produces an error.

I read in the Oracle v7.2 documentation that this version uses Job Queues to schedule routines to be performed periodically. But this feature is not avaible in Oracle v7.0, although it allows create a SNP background process in order to automatic refresh snapshots.

Alberto Rivera Received on Tue Oct 01 1996 - 00:00:00 CEST