Name

CREATE/ALTER/DROP SNAPSHOT LOG

Synopsis

CREATE Syntax:

CREATE SNAPSHOT LOG ON [schema.]table_name
[Physical_Attributes_Clause]
[TABLESPACE tablespace_name]   
[Storage_Clause]

ALTER Syntax:

ALTER SNAPSHOT LOG ON [schema.]table_name
[Physical_Attributes_Clause]
[Storage_Clause]

DROP Syntax:

DROP SNAPSHOT LOG ON [schema.]table_name

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

Keywords

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.

Common keywords and clauses: Physical_Attributes_Clause, Storage_Clause, schema, table_name, tablespace_name.

Get Oracle in a Nutshell now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.