RE: snapshot refresh
Date: Fri, 31 Oct 2008 15:22:05 -0400
But not all snapshot refreshes are performed via dbms_job. It has been possible at least since Oracle8i to perform a refresh on demand.
Prime Services Databases Americas
One Madison Avenue
New York, NY 10010
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael Fontana Sent: Friday, October 31, 2008 3:13 PM
To: piontekdd_at_gmail.com; joe_dba_at_hotmail.com; oracle-l_at_freelists.org Subject: RE: snapshot refresh
If you want to know if the snapshot is running at the present time:
The view DBA_JOBS_RUNNING on the target system will have a row in it corresponding to the value in the JOB column for this snapshot in DBA_JOBS. If you're concerned about the job running during the upgrade, and how to handle such things in general, this is covered in the upgrade steps for both 9i and 10g releases, and is something that needs to be followed pretty precisely, or the job may not run correctly after an upgrade. Please make a point to review these steps and detail.
On Behalf Of Bradd Piontek
Sent: Friday, October 31, 2008 2:01 PM
To: joe_dba_at_hotmail.com; oracle-l_at_freelists.org Subject: Re: snapshot refresh
Check out dba_snapshot_refresh_times on the target. Or check the last_date in dba_jobs
On 10/31/08, Joe Smith <joe_dba_at_hotmail.com> wrote:
> 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
> 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
> Stay organized with simple drag and drop from Windows Live Hotmail.
-- Sent from my mobile device Bradd Piontek "Next to doing a good job yourself, the greatest joy is in having someone else do a first-class job under your direction." -- William Feather -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l ============================================================================== Please access the attached hyperlink for an important electronic communications disclaimer: http://www.credit-suisse.com/legal/en/disclaimer_email_ib.html ============================================================================== -- http://www.freelists.org/webpage/oracle-lReceived on Fri Oct 31 2008 - 14:22:05 CDT