Edit Materialized View

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

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.

Query

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

Materialized View Info

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

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.

Index

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

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.

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