Create Materialized View

It describes how to create the Materialized View with Gui Operation

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

Materialized View Folder > Context Menu > Create Materialized View

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

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

Common

Sets the Schema, Name of the Materialized View to be created.

Field

Description

Schema

Select the Schema to create the Materialized View.

Default: Current Connection Created Schema

Name

Enter the name of the Materialized View to be created.

Query

Create a query to create a Materialized View.

The detailed operation is the same as Create View > Query tab. Query

Materialized View Info

Set the information of the Materialized View to be created.

Refresh Setting
Field
Description
Refresh Mode
Select the Refresh Mode.
On Demand (default): Refresh is performed only when the user calls the REFRESH prerequisite of the DBMS_MVIEW package.
On Commit: Refresh is performed every time a commit is made to the master table.
Time: Select the date type expression at which the first refresh occurs. If selected, the bottom Start with, Next fields are enabled.
Never Refresh: Never perform an automatic refresh. The bottom fields are all disabled.
Start With
Set the date from which the refresh will begin.
Enabled when Time is selected in Refresh Mode.
Next
Set the interval for Refresh.
Enabled when Time is selected in Refresh Mode.
Refresh Method
Select the refresh method.
Force: Performs a quick refresh if a quick refresh is available, otherwise performs a full refresh.
Fast: Performs a quick refresh.
Complete (default): Performs a complete refresh by re-executing the query that defines the Materialized View.
With
Selects the identifier to use for synchronization on refresh.

Build Setting
Field
Description
Build Mode
Select the Build Mode.
Immediate (Default): Insert data as soon as the Materialized View is created.
Deferred: Insert data when refreshing for the first time.
Prebuilt Table -Default (Without Reduced Precision): The precision of the columns in the table should match the result of the query that defined the Materialized View. When selected, the fields on the Storage tab are not configurable.
Prebuilt Table (With Reduced Precision): Allows the precision of the columns in the table to differ from the results of the query that defined the Materialized View. When selected, the fields on the Storage tab are not configurable.
Query Rewrite Enable
Materialized View is used for rewriting queries.

Storage

Set the physical properties of the storage space and the Tablespace and Segment properties of the Materialized View to be created.

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

Note

If the build mode is selected as Prebuilt Table - Default (Without Reduced Precision) or Prebuilt Table (With Reduced Precision) in the Materialized Info tab, all fields in that tab cannot be set.