Docs Home

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.

Last updated