Oracle SQL: the Essential Reference

CREATE/ALTER/DROP SNAPSHOT

CREATE SNAPSHOT [schema.]snapshot_name [Physical_Attributes_Clause] [TABLESPACE tablespace] [STORAGE Storage_Clause] [REFRESH [FAST | COMPLETE | FORCE] [START WITH date] [NEXTREF date] AS snapshot_query

Creates a snapshot, which is the result of a query run against one or more tables or views.

ALTER SNAPSHOT [schema.]snapshot_name
  [Physical_Attributes_Clause]
  [STORAGE Storage_Clause]
  [REFRESH
     [FAST | COMPLETE | FORCE]
     [START WITH date]
     [NEXTREF date]

Changes the storage or automatic refresh characteristics of a snapshot.

DROP SNAPSHOT [schema.]snapshot_name

Removes a snapshot from the database.

Keywords

Physical_Attributes_Clause

Specifies physical attributes of this snapshot. See Chapter 4 for detailed information.

TABLESPACE

Specifies the name of the tablespace where this snapshot will be stored. If omitted, the default tablespace for the schema owner will be used.

STORAGE

Specifies physical storage characteristics. See Chapter 4 for detailed information.

REFRESH

Specifies the mode and times for automatic refreshes. FAST means use the snapshot log associated with the master table; COMPLETE means refresh by re-executing the snapshot's query; FORCE is the default, and indicates that Oracle will decide if a FAST refresh is possible or a COMPLETE refresh is necessary.

START WITH

Specifies a date for the next automatic refresh time using a standard Oracle date expression.

NEXTREF

Specifies a new date expression for calculating the interval between automatic ...