---
description: It describes how to create the Materialized View with Gui Operation
---

# Create Materialized View

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

**Materialized View Folder > Context Menu > Create Materialized View**&#x20;



The details can be set in each tab: [#common](#common "mention"), [#query](#query "mention"), [#materialized-view-info](#materialized-view-info "mention"), [#storage](#storage "mention"), [#index](#index "mention"), [#partition](#partition "mention"), [#comment](#comment "mention")&#x20;

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/e2oIBtnJOyzw3of57n6Y/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2018-36-37.png" alt=""><figcaption><p>Create Materialized View screen</p></figcaption></figure>

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.

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/VBDvwKLvJIRhD9R33aek/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2018-37-02.png" alt=""><figcaption><p>Create Materialized View - Common tab screen</p></figcaption></figure>

<table><thead><tr><th width="117">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Schema</strong></td><td><p>Select the Schema to create the Materialized View. </p><p>Default: Current Connection Created Schema </p></td></tr><tr><td><strong>Name</strong></td><td>Enter the name of the Materialized View to be created.</td></tr></tbody></table>





## Query

Create a query to create a Materialized View.

The detailed operation is the same as **Create View > Query tab**. [#query](../../view/create-view#query "mention")

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/j6U6KPIyx1M4ABBfXny5/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2018-38-19.png" alt=""><figcaption><p>Create Materialized View - Query tab screen</p></figcaption></figure>





## Materialized View Info

Set the information of the Materialized View to be created.

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/0nDreMzqM6FmfgR1I3l6/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2018-38-56.png" alt=""><figcaption><p>Create Materialized View - Materialized View Info tab screen</p></figcaption></figure>

*   Refresh Setting

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



*   Build Setting

    <table><thead><tr><th width="169">Field</th><th>Description</th></tr></thead><tbody><tr><td><strong>Build Mode</strong></td><td><p>Select the Build Mode.</p><ul><li>Immediate (Default): Insert data as soon as the Materialized View is created.</li><li>Deferred: Insert data when refreshing for the first time.</li><li>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.</li><li>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. </li></ul></td></tr><tr><td><strong>Query Rewrite Enable</strong></td><td>Materialized View is used for rewriting queries.</td></tr></tbody></table>





## Storage

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

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/1iKAw2DLCjY0uBMg4OYm/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2018-40-15.png" alt=""><figcaption><p>Create Materialized View - Storage tab screen</p></figcaption></figure>

For detailed fields, see the **Create Table > Storage** tab.  [#storage](../../table/create-table#storage "mention")

{% hint style="info" %}
**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.
{% endhint %}





## Index

Sets the Index of the Materialized View to be created.

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/ZkBn9xu5iRlxSkyBO6wO/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2018-41-04.png" alt=""><figcaption><p>Create Materialized View - Index tab screen</p></figcaption></figure>

The detailed fields and work are the same as [#indexes](../../table/create-table#indexes "mention").





## Partition

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

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/mPZ8vJS7mXS2qMAKWurb/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2018-42-14.png" alt=""><figcaption><p>Create Materialized View - Partition tab screen</p></figcaption></figure>

The detailed work is the same as the **Create Table > Partition** tab. [#partition](../../table/create-table#partition "mention")





## Comment

Create a Comment for the Materialized View to be created.

<figure><img src="https://content.gitbook.com/content/nNfkYJbwJttSkGBYdvi9/blobs/qO61mXMrdo1K59BfAPCG/%EC%8A%A4%ED%81%AC%EB%A6%B0%EC%83%B7,%202025-02-27%2018-42-49.png" alt=""><figcaption><p>Create Materialized View - Comment tab screen</p></figcaption></figure>

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

###
