Name
CREATE/ALTER/DROP SNAPSHOT LOG
Synopsis
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).
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.