OraFAQ Forum: SQL & PL/SQL » Writable MVIEW

Home » SQL & PL/SQL » SQL & PL/SQL » Writable MVIEW (Oracle 9i)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Writable MVIEW [message #564202]

Wed, 22 August 2012 01:23

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.

Report message to a moderator

Re: Writable MVIEW [message #564203 is a reply to message #564202]

Wed, 22 August 2012 01:25

Michel Cadot
Messages: 54236
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

Report message to a moderator

Re: Writable MVIEW [message #564205 is a reply to message #564203]

Wed, 22 August 2012 01:37

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.

Report message to a moderator

Re: Writable MVIEW [message #564207 is a reply to message #564205]

Wed, 22 August 2012 01:54

John Watson
Messages: 3112
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.

Report message to a moderator

Re: Writable MVIEW [message #564208 is a reply to message #564205]

Wed, 22 August 2012 01:54

Michel Cadot
Messages: 54236
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Did you check the documentation before posting this question?

Regards
Michel

Report message to a moderator

Re: Writable MVIEW [message #564216 is a reply to message #564208]

Wed, 22 August 2012 02:30

ramesh55.sse
Messages: 262
Registered: December 2008
Location: Hyderabad

Senior Member

I Have checked the documentation,
but in that no business scenario.

Report message to a moderator

Re: Writable MVIEW [message #564217 is a reply to message #564216]

Wed, 22 August 2012 02:56

Michel Cadot
Messages: 54236
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

Report message to a moderator

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

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 24 15:32:58 CDT 2013

Total time taken to generate the page: 0.33888 seconds