December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE/ALTER/DROP SNAPSHOT LOG
CREATE Syntax:
CREATE SNAPSHOT LOG ON [schema.]table_name[Physical_Attributes_Clause] [TABLESPACEtablespace_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).
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.