Re: materialized views - please help

[Sai Selvaganesan]

arup

 

the bug says it is fixed in 9. i run 9.2.0.4 on windows 2k.

 

still having this issue.

 

these invalid mvs affect the performance.

 

thanks

sai

Arup Nanda <[EMAIL PROTECTED]> wrote:

Sai,

 

You may want to check bug# 1188948; it sounds like your case.

 

HTH.

 

Arup

----- Original Message -----

From: Sai Selvaganesan

To: Multiple recipients of list ORACLE-L

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