|
Sai,
You may want to check bug# 1188948; it sounds like your
case.
HTH.
Arup
----- Original Message -----
Sent: Tuesday, August 26, 2003 9:04
PM
Subject: materialized views
hi
materialized views become invalid as soon as a complete or fast refresh
of the mv is done. is this how it is supposed to work?
the status is invalid in dba_objects and is set to 'N' in
dba_mview_analysis. i have been struggling to understand this. i read thru few
docs on metalink which talk about query rewrite enabled blah..blah.. but
nothing seems to work.
can some tell me what has to be done. it is mandatory for me to validate
the mvs after every refresh..
thanks
sai
|
