Re: MV refresh

From: Thomas Day <tomdaytwo_at_gmail.com>
Date: Wed, 2 Sep 2009 15:06:47 -0400
Message-ID: <9f0e18730909021206l6cdc4b62sec6d78575623103e_at_mail.gmail.com>

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:
http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:616795500346622064

--
http://www.freelists.org/webpage/oracle-l

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