Re: Snapshot refresh interval

From: Nicky Taylor <nicky.taylor_at_gecm.com>
Date: Wed, 1 Dec 1999 08:46:19 -0000
Message-ID: <3844df44@pull.gecm.com>

The syntax for creating a snapshot is:-

create snapshot my_snapshot
<storage options>
<tablespace>

refresh [FAST | COMPLETE | FORCE]
start with <start_date>
next <refresh_interval>
as
<select statement>

The FAST refresh option only updates the snapshot with the rows that have changed since the last refresh.
The COMPLETE option re-creates the whole snapshot each time. The FORCE option uses either fast or complete depending on which is available at the time.

It is possible to manually refresh with the following command:-

execute DBMS_SNAPSHOT.REFRESH ('my_snapshot', '<refresh_option>');

where <refresh_option> is 'F' for fast, 'C' for complete or '?' for the default refresh of the snapshot.

HTH Nicky Taylor Received on Wed Dec 01 1999 - 02:46:19 CST