RE: snapshot refresh

From: Goulet, Richard <>
Date: Fri, 31 Oct 2008 14:52:02 -0400
Message-ID: <>


    If it's a fast refresh, then it has to have a log table where changes are logged till the next refresh has happen. Check the number of rows therein. If it's close to 0 then you can be assured of one of two things 1) there are few is any refreshes to the table in which case why you want a refresh process to run is questionable or 2) the refresh process is running successfully since as the rows get refreshed the process deletes them from the log table. Also you can look on the target database & see if the job there is running, use DBA_JOBS/USER_JOBS to tell, LAST_DATE and BROKEN will let you know or NEXT_DATE will be out in the year 4001 or something close thereto if it's broken.  

Dick Goulet
Senior Oracle DBA
PAREXEL International
 information transmitted in this communication is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please destroy any copies, contact the sender and delete the material from any computer.  

[] On Behalf Of Joe Smith Sent: Friday, October 31, 2008 2:43 PM
Subject: snapshot refresh

I have 2 8i databases that I need to upgrade that I have inherited.  

There is 1 master table that is being snaphot refreshed to the second database.  

It is done by " refresh fast with primary key". No multiple tables or updating the master.  

What is the most accurate way to tell if a snapshot refresh is running?  


Stay organized with simple drag and drop from Windows Live Hotmail. Try it

Received on Fri Oct 31 2008 - 13:52:02 CDT

Original text of this message