Re: Snapshot Log creation

From: Kevin Loney <Kevin.Loney_at_astramerck.com>
Date: Wed, 11 Nov 1998 10:39:42 -0500
Message-ID: <4di22.1625$8T2.2942368@newshog.newsread.com>

>Since snapshot log is used only if Oracle needs to perform FAST REFRESH
>of snapshot, is snapshot log required to be created when we always use
>COMPLETE REFRESH on snapshot.

No. You're just wasting space in the master database, since you're never using the log. If you drop the snapshot log, then you won't be able to do a fast refresh.

hth.
Kevin.
http://www.kevinloney.com Received on Wed Nov 11 1998 - 09:39:42 CST