Snapshot invalid during refresh job execution (COMPLETE)

Hi,
I've noticed the status of a snapshot changes to INVALID every time its job of COMPLETE REFRESH is run, then it gets back to a valid state once the refresh has completed.

I'd just like to know whether it's normal (our snapshots in FAST REFR. mode do not show this momentary change, DBA_OBJECTS.STATUS remains to 'VALID') or not.

Thanks.
Spendius Received on Thu Feb 12 2004 - 03:28:37 CST