Name
CREATE/ALTER/DROP MATERIALIZED VIEW LOG
Synopsis
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.
Keywords
- table_name
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.
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.