This discussion is archived
3 Replies Latest reply: Oct 25, 2013 1:48 PM by TSharma-Oracle Branched from an earlier discussion. RSS

Re: does materialized view truncate during a full refresh?

swarner Newbie
Currently Being Moderated

I was looking for the behavior of the Refresh on the underlying data, wondering if the there was a truncate parameter. According to the docs the atomic refresh has to do with how the transaction is handled and not how the data is removed from the table.

 

from the docs posted above it does not specifiy delete or truncate just

 

atomic_refresh   

 

If this parameter is set to true, then the list of materialized
views is refreshed in a single transaction. All of the refreshed materialized
views are updated to a single point in time. If the refresh fails for any of the
materialized views, none of the materialized views are updated.

 

If this parameter is set to false, then each of the materialized
views is refreshed in a separate transaction.

 

 

Then after some more searching askTom does state that a

in 10g and above you would use atomic_refresh=>FALSE

 

that permits us to user  truncate+insert/*+APPEND*/

Ask Tom "Complete MV Refresh Uses Delete vs Trunc..."

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points