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: 4502
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: DBMS_UTLITY
Next Topic: Skip in sequence
Goto Forum:

Current Time: Tue Oct 25 03:54:02 CDT 2016

Total time taken to generate the page: 0.07406 seconds