Home » SQL & PL/SQL » SQL & PL/SQL » Materialised view refresh on commit (Oracle 10.2.0.4.0)
Materialised view refresh on commit [message #647909] Thu, 11 February 2016 07:44 Go to next message
brown_zzz
Messages: 39
Registered: August 2012
Location: United Kingdom
Member
I have a materialised view set to 'refresh on commit'

If a process INSERTS data to the base tables and then issues a commit will the materialised view finish refreshing before the commit of the process or after ?

Report message to a moderator

Re: Materialised view refresh on commit [message #647910 is a reply to message #647909] Thu, 11 February 2016 07:48 Go to previous message
John Watson
Messages: 8930
Registered: January 2010
Location: Global Village
Senior Member
It is done as part of the same transaction.

Report message to a moderator

Previous Topic: using case when ..need suggestion
Next Topic: Can any one help to remove duplicate rows in a table
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 13:30:13 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.