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

Create Materialized View screen

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.

Create Materialized View - Common tab screen

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

Create Materialized View - Query tab screen

Materialized View Info

Set the information of the Materialized View to be created.

Create Materialized View - Materialized View Info tab screen

• 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.

Create Materialized View - Storage tab screen

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.

Index

Sets the Index of the Materialized View to be created.

Create Materialized View - Index tab screen

The detailed fields and work are the same as Indexes.

Partition

Sets the Partition and SubPartition of the Materialized View to be created.

Create Materialized View - Partition tab screen

The detailed work is the same as the Create Table > Partition tab. Partition

Comment

Create a Comment for the Materialized View to be created.

Create Materialized View - Comment tab screen

Click [Reset button] to initialize the creation contents.

After setting the details of each tab, click [Ok button] to create a Materialized View object with the settings