Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> SNAPSHOT problem....(its strange)

SNAPSHOT problem....(its strange)

From: shailesh y <dba_account_at_yahoo.com>
Date: Wed, 9 Aug 2000 10:52:49 -0700 (PDT)
Message-Id: <10584.114198@fatcity.com>


Hi all,

  Today I altered my snapshot on DW to refresh after every 5 minutes(for test purpose before altering all 142 snapshots) These snapshot did not have any 'START WITH' or 'NEXT' specified. This job is otherwise being done by CRON..

ALTER SNAPSHOT book_titles
 REFRESH NEXT SYSDATE+5/1440; I did not get any LAST_REFERESH values updated after a long time and when i querried the
MLOG$_BOOK_TITLES(snapshot log) on the remote database it had started stamping SNAPTIME$$
as 01-01-4000 00:00:00.
These snapshot had been created by old DBA whose not around. Has anybody experienced the same problem... please enlighten as to how should i implement this auto update thru Oracle...

TIA
Shailesh



Do You Yahoo!?
Kick off your party with Yahoo! Invites. Received on Wed Aug 09 2000 - 12:52:49 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US