Re: snapshot refresh

  • From: "Bradd Piontek" <piontekdd@xxxxxxxxx>
  • To: joe_dba@xxxxxxxxxxx, oracle-l@xxxxxxxxxxxxx
  • Date: Fri, 31 Oct 2008 14:01:07 -0500

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@xxxxxxxxxxx> 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
> 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?
>
> thanks.
> _________________________________________________________________
> Stay organized with simple drag and drop from Windows Live Hotmail.
> http://windowslive.com/Explore/hotmail?ocid=TXT_TAGLM_WL_hotmail_102008

-- 
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
--
//www.freelists.org/webpage/oracle-l


Other related posts: