Hi,
I've encounter a weird problem today on some snapshot on a database.
I did a select on dba_snapshots and I get the following :
OWNER NAME
TABLE_NAME MAST
VIEW
------------------------------ ------------------------------
- ----
MASTER_OWNER MASTER
- ------------------------------
MASTER_LINK
CAN UPD REFRESH_MET
- --- --- -----------
LAST_REF ERROR FR_OPERATI CR_OPERATI TYPE
-------- ---------- ---------- ---------- --------
NEXT
START_WI REFRESH_GROUPla UPDATE_TRIG UPDATE_LOG
-------- ------------- ------------------------------
QUERY
MASTER_ROLLBACK_
STATUS REFRESH_ PRE
- ------- -------- ---
CHATDBA T_SPORT T_SPORT
CHATDBA T_SPORT
@RELAIS5
YES NO PRIMARY KEY
01/01/50 ########## REGENERATE VALID COMPLETE
SYSDATE+1
28/02/06 73
SELECT "T_SPORT"."SPT_ID" "SPT_ID","T_SPORT"."SPT_TEXT"
"SPT_TEXT","T_SPORT"."LA
VALID PERIODIC NO
The weird thing is the last refresh which is set on 01/01/50.
The complete refresh seems to be running daily but the date is not
updated and that makes me tickle ...
Any idea why ?
TIA,
Andy
Received on Mon Feb 27 2006 - 11:14:54 CST