# Create Materialized View Log 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](#common "mention"), [#columns](#columns "mention"), [#storage](#storage "mention")

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.

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. /pages/AHwPHq9uKXeW5uf3Hn4M#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**. [Create Table](/tiberostudio.en/about/schema-tree-browser/table/create-table.md#storage) After completing the detailed settings on each tab, click the **\[OK button]** to create a Materialized View Log object with the settings. ### --- # Agent Instructions: Querying This Documentation If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question. Perform an HTTP GET request on the current page URL with the `ask` query parameter: ``` GET https://docs.tibero.com/tiberostudio.en/about/schema-tree-browser/materialized-view-log/create-materialized-view-log.md?ask= ``` The question should be specific, self-contained, and written in natural language. The response will contain a direct answer to the question and relevant excerpts and sources from the documentation. Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.