Oracle SQL: the Essential Reference

CREATE/ALTER/DROP MATERIALIZED VIEW LOG

CREATE MATERIALIZED VIEW LOG ON [schema.]tablename [Physical_Attributes_Clause] [TABLESPACE tablespace] [STORAGE Storage_Clause]

Creates a materialized view log, which is a table associated with the master table of a materialized view used to control materialized view refreshes.

ALTER MATERIALIZED VIEW LOG ON [schema.]tablename
  [Physical_Attributes_Clause]
  [STORAGE Storage_Clause]

Changes the materialized view log's storage characteristics.

DROP MATERIALIZED VIEW LOG ON [schema.]table_name

Removes a materialized view log from the database.

Keywords

tablename

Specifies the name of the table for which the materialized view log will be maintained.

Physical_Attributes_Clause

Specifies the physical characteristics of this materialized view log. See Chapter 4 for detailed information.

TABLESPACE

Specifies the name of the tablespace in which this materialized view log will be created. The default tablespace for the schema owner is the default.

STORAGE

Specifies the physical storage characteristics. See Chapter 4 for detailed information.

Examples

Create a materialized view log on scott's emp table:

CREATE MATERIALIZED VIEW LOG scott.emp
   STORAGE (INITIAL 50K NEXT 50K PCTINCREASE 0)
   TABLESPACE USERS;

Change the next extent size for the materialized view log on scott's emp table to 50K:

ALTER MATERIALIZED VIEW LOG scott.emp
   STORAGE (NEXT 50K);

Remove the materialized view log associated with scott's emp table from the database:

DROP MATERIALIZED ...