December 2002
Intermediate to advanced
928 pages
85h 29m
English
CREATE/ALTER/DROP MATERIALIZED VIEW LOG
CREATE Syntax:
CREATE MATERIALIZED VIEW LOG ON [schema.]table_name[Physical_Attributes_Clause] [TABLESPACEtablespace_name] [Storage_Clause]
ALTER Syntax:
ALTER MATERIALIZED VIEW LOG ON [schema.]table_name[Physical_Attributes_Clause] [Storage_Clause]
DROP Syntax:
DROP MATERIALIZED VIEW LOG ON [schema.]table_name
Creates, modifies, or removes a materialized view log, which is a table associated with the master table of a materialized view used to control materialized view refreshes. New with Oracle8i.
Specifies the name of the table for which the materialized view log will be maintained.
Common keywords and clauses: Physical_Attributes_Clause, schema, Storage_Clause, table_name, tablespace_name.