Home » SQL & PL/SQL » SQL & PL/SQL » Writable MVIEW (Oracle 9i)
Writable MVIEW [message #564202] Wed, 22 August 2012 01:23 Go to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
Hi Experts,

What are the advantages of writable materialized views.
Please provide one business scenario when will we use writable materialized views.
Please help me.
Thanks in advance.

Re: Writable MVIEW [message #564203 is a reply to message #564202] Wed, 22 August 2012 01:25 Go to previous messageGo to next message
Michel Cadot
Messages: 59165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You can update them.
Did you check the documentation before posting this question?

Regards
Michel
Re: Writable MVIEW [message #564205 is a reply to message #564203] Wed, 22 August 2012 01:37 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
I Know that we can update it.
But I want to know in which business scenario will we use it.
Re: Writable MVIEW [message #564207 is a reply to message #564205] Wed, 22 August 2012 01:54 Go to previous messageGo to next message
John Watson
Messages: 4576
Registered: January 2010
Location: Global Village
Senior Member
Updatable MVs are useful only if you are using materialized view replication between databases. They would be useless within a database, where the purpose of a materialized view is query re-write.
Re: Writable MVIEW [message #564208 is a reply to message #564205] Wed, 22 August 2012 01:54 Go to previous messageGo to next message
Michel Cadot
Messages: 59165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Did you check the documentation before posting this question?


Regards
Michel
Re: Writable MVIEW [message #564216 is a reply to message #564208] Wed, 22 August 2012 02:30 Go to previous messageGo to next message
ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad
Senior Member
I Have checked the documentation,
but in that no business scenario.
Re: Writable MVIEW [message #564217 is a reply to message #564216] Wed, 22 August 2012 02:56 Go to previous message
Michel Cadot
Messages: 59165
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Which documentation did you read? Post links.
Business scenario: multi-master replication.

Regards
Michel
Previous Topic: Creating Oracle database to support chinese fonts
Next Topic: How to return in one row only
Goto Forum:
  


Current Time: Mon Sep 22 11:52:13 CDT 2014

Total time taken to generate the page: 0.08467 seconds