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

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
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: 68165
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.

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

Current Time: Thu May 19 17:30:23 CDT 2022