Home » Server Options » Replication » Meterialized view help (oracle, 9.2.0.3)
Meterialized view help [message #556696] Wed, 06 June 2012 03:00 Go to next message
sathik
Messages: 196
Registered: August 2009
Location: INDIA
Senior Member
Hi,

I have a mview in a table. Today I created one more Mview on the same table. When I start the complete refresh activity in the new mview, the old mview got invalid.And asking me to do a complete refresh.Now I am doing complete refresh.

I just want to understand the technical background of this. will complete refresh make other mviews INVALID, if both views created for a same table? What are the precautions I have to take infuture to avoid this kind of problem?
Re: Meterialized view help [message #560202 is a reply to message #556696] Wed, 11 July 2012 04:16 Go to previous messageGo to next message
moulshree
Messages: 13
Registered: July 2012
Junior Member
Please post your MV definitions and error messages.
Re: Meterialized view help [message #560207 is a reply to message #560202] Wed, 11 July 2012 05:00 Go to previous message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
He he, a junior member reminds to a senior one how he should post.

Regards
Michel
Previous Topic: error ogg-00963
Next Topic: Materialized view
Goto Forum:
  


Current Time: Thu Mar 28 07:37:23 CDT 2024