Home » SQL & PL/SQL » SQL & PL/SQL » How to referesh materialzed partly
How to referesh materialzed partly [message #236895] Fri, 11 May 2007 04:05 Go to next message
Messages: 95
Registered: February 2007

Is there anyway to refresh materialized view partially or can use merge statement. Can any one give good examplew for querry rewrite option.

Thanks ina advance

[Updated on: Fri, 11 May 2007 04:34]

Report message to a moderator

Re: How to referesh materialzed partly [message #237083 is a reply to message #236895] Fri, 11 May 2007 16:06 Go to previous message
Frank Naude
Messages: 4525
Registered: April 1998
Senior Member
Use "fast refresh" with MV LOGS to enable "partial" MV updates.

PS: There are some very good examples in the Data Warehousing Guide.
Previous Topic: Doubt in alphanumeric vaidation
Next Topic: Complex Calculations
Goto Forum:

Current Time: Wed Aug 23 20:19:48 CDT 2017

Total time taken to generate the page: 0.03499 seconds