Create Materialized View Log

It describes how to create the Materialized View Log object with Gui Operation.

Materailized View Log object can be created through the GUI operation as executing the following process.

MView Log Folder > Context Menu > Create Materialized View Log

The details can be set in each tab:Common, Columns, Storage

Create Materialized View Log screen

SQL applied to the settings is shown in the bottom SQL area.

Common

Set the Schema and Table name of the Materialized View Log to be created.

Create Materialized View Log - Common tab screen

Field	Description
Schema	Selects a Schema to create a Materialized View Log Default: Current ConnectionCreated Schema
Table Name	Selects a target table of the Materialized View Log to create. A list of tables in the selected Schema appears.

Columns

Select the column to set the Materialized View Log to be created.

Create Materialized View Log - Columns tab screen

Field	Description
New Values	Selects whether to log only the pre-change value of the column or both the pre- and post-change values.
Row ID	Selects whether to log the ROWID of the changed row of the master table.
Primary Key	Selects whether to log the PRIMARY KEY of the changed row of the master table.
Sequence	Selects whether to record the changed sequence of the master table.
Select Colums	Selects the columns to record. When the users click the Add Column button, the column list of the selected table appears on the Common tab. The details of the Column List are the same as the Column List on the Create Table > Columns tab. Columns

Storage

Sets the physical properties of storage space and detailed properties of Tablespace and Segment.

Create Materialized View Log - Storage tab screen

For detailed fields, see Create Table > Storage tab. Storage

After completing the detailed settings on each tab, click the [OK button] to create a Materialized View Log object with the settings.