Home » Server Options » Replication » Materalized views and fast and complete refresh
Materalized views and fast and complete refresh [message #230957] Fri, 13 April 2007 09:42 Go to next message
olona
Messages: 1
Registered: April 2007
Location: Oslo
Junior Member
Hey all.

When you do a complete refresh of a materialized view, does it do a truncate prior and then populate it, in effect removing the table for as long as its rebuilding it?

Re: Materalized views and fast and complete refresh [message #232815 is a reply to message #230957] Mon, 23 April 2007 06:57 Go to previous messageGo to next message
tahpush
Messages: 961
Registered: August 2006
Location: Stockholm/Sweden
Senior Member

complete means - build from scratch
No truncating etc,you can't access it during build

more info
Re: Materalized views and fast and complete refresh [message #232857 is a reply to message #230957] Mon, 23 April 2007 12:06 Go to previous message
gintsp
Messages: 118
Registered: February 2007
Senior Member
in 9i mechanism is truncate/insert /*+ append */
in 10g default is delete/conventional insert, although one can switch back to 9i mechanism using atomic_refresh = false in dbms_mview.refresh proc.

Gints Plivna
http://www.gplivna.eu
Previous Topic: MV Issue
Next Topic: Clarification for Replication
Goto Forum:
  


Current Time: Tue Jul 22 02:45:28 CDT 2014

Total time taken to generate the page: 0.05377 seconds