Re: MV refresh

From: Thomas Day <>
Date: Wed, 2 Sep 2009 15:06:47 -0400
Message-ID: <>

A complete refresh in 10g does a truncate and insert append.

With atomic refresh =>false it also automatically marks the indexes as unusable and rebuilds them in place after the refresh.

Unless you have a really shaky network I don't know of too many scenarios that would leave you with 0 rows in your snapshots (except for when there are 0 rows in your source).

Ask Tom has a nice discussion here:

Received on Wed Sep 02 2009 - 14:06:47 CDT

Original text of this message