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