Community Basic Replication — 6 : COMPLETE and ATOMIC_REFRESH by SSWUG Research (Hemant K Chitale) Till 9i, if you did a COMPLETE Refresh of a Single Materialized View, Oracle would do a TRUNCATE followed by an INSERT. Register to Read