Oracle SQL: the Essential Reference

CREATE/ALTER/DROP SNAPSHOT LOG

CREATE SNAPSHOT LOG ON [schema.]tablename [Physical_Attributes_Clause] [TABLESPACE tablespace] [STORAGE Storage_Clause]

Creates a snapshot log (a table associated with the master table of a snapshot and used to control refreshes of snapshots).

ALTER SNAPSHOT LOG ON [schema.]tablename
  [Physical_Attributes_Clause]
  [STORAGE Storage_Clause]

Changes the storage characteristics of a snapshot log.

DROP SNAPSHOT LOG ON [schema.]table_name

Removes a snapshot log from the database.

Keywords

tablename

Specifies the name of the table for which the snapshot log will be maintained.

Physical_Attributes_Clause

Specifies the 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 the physical storage characteristics. See Chapter 4 for detailed information.

Examples

Create a snapshot log on scott's emp table:

CREATE SNAPSHOT LOG ON scott.emp
   STORAGE (INITIAL 50K NEXT 50K PCTINCREASE 0)
   TABLESPACE users;

Change the next extent size for the snapshot log on scott's emp table to 500K:

ALTER SNAPSHOT LOG scott.emp
   STORAGE (NEXT 500K);

Remove the snapshot log associated with scott's emp table from the database:

DROP SNAPSHOT LOG ON scott.emp;