Edit Materialized View

It describes how to modify a Materialized View object using GUI operations.

Execute Materialized View > Context Menu > Edit Materialized View to edit the Materialized View object through Gui Operation.

The details can be set in each tab: Common, Query, Materialized View Info, Storage, Index, Comment

Edit Materialized View screen

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

Common

Check the Schema and Name of Materialized View be modified, and each field cannot be modified.

Edit Materialized View - Common tab screen

Query

The users can check the query that created the Materialized View to be edited. The query cannot be modified.

Edit Materialized View - Query tab screen

Materialized View Info

The users can check and modify the information of the materialized view to be modified.

Edit Materialized View - Materialized View Info tab screen

For detail fields, it is the same as Create Materialized View > Materialized View Info tab.Materialized View Info

The Build Mode field is not editable.

Storage

The users can check the physical properties of the storage space and detailed properties of Tablespace and Segment of the Materialized View to be modified.

Each field is not editable.

Edit Materialized View - Storage tab screen

Index

The users can check and modify the index of the materialized view to be modified.

Edit Materialized View - Index tab screen

For an existing index, the users can only edit the Name field.

The detailed operation is the same as Create Table > Indexes tab. Indexes

Comment

The users can check and edit the existing Comment information of the Materialized View to be modified.

Edit Materialized View - Comment tab screen

After completing the modifications on each tab, click the [Ok button] at the bottom right to apply the modifications.