This content has been marked as final. Show 3 replies
Starting from 10g, Oracle gives you an option to decide how you want the refresh to take place. The DBMS_MVIEW.REFRESH procedure has a boolean parameter called ATOMIC_REFRESH whose default value (in 10g) is TRUE. It means
TRUE => DELETE + INSERT
FALSE => TRUNCATE + INSERT
For more details, documentation is your friend.