Materialized Views Editor (Oracle)

From RapidSQL
Jump to: navigation, search

Go Up to Oracle Object Editors

The Materialized Views Editor lets you view and modify materialized view information and partitions.

To edit a materialized view

  1. Open an editor on the materialized view. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks

Information

Lets you work with properties in the following categories:

Master

Lets you work with the Table Name and Master View properties.

Last Refresh

Lets you work with the Last Date and Errors properties.

Refresh Configuration

Lets you work with the Type, Refresh Method, and Mode properties.

Rollback Usage

Lets you work with the Local and Master properties.

Options

Lets you work with the Updatable and Enable Query Rewrite properties.

Storage

Lets you work with properties in the following categories:

Placement

Lets you work with Tablespace and Cluster values.

Data Block Storage

Lets you work with Percent Free, Percent Used, Initial transactions, and Maximum transactions values.

Extents

Lets you work with Initial Extent, Next Extent, Minimum Extents, Maximum Extents, and Percent Increase values.

Performance

Lets you work with settings in the following categories:

Parallel Query Option

The Parallel server query option lets you process queries using many query server processes running against multiple CPUs. This option provides substantial performance gains such as reduction of the query completion time. Degrees - Lets you type a value indicating the number of query server processes that should be used in the operation. Instances - Lets you type a value indicating how you want the parallel query partitioned between the Parallel Servers.

Logging

Select Logging to create a log for all Materialized View updates.

Cache

Select Cache if you want Oracle to put data you access frequently at the most recently used end of the list in the buffer cache when a full table scan is performed. This option is useful for small lookup tables.

Query

Displays the associated query.

Partitions

Partitioning Method

Displays the partitioning method, including Range-Hash Composite or Range-List Composite. Hash partitions partition the table according to a hash function. Composite partitions use both range and hash types, first partitioning the data by a range of values, and then further dividing the partitions into subpartitions by way of a hash function. List partitioning lets you control how rows map to partitions. You can specify a list of discrete values for the partitioning column in the description for each partition.

Row Movement

If its key is updated, migrates the row to a new partition.

Partitioning Columns

Displays partitioning columns.

Subpartitioning Columns

Displays subpartitioning columns.

Partitions

Click Add or Edit to open the Partition dialog. Click Drop to drop a partition.

Subpartition Template

If the partitioning type is Range-Hash Composite, displays a list of subpartitions in the subpartition template. Click Add, Insert, or Edit to open the Subpartition dialog. Click Drop to drop a subpartition.

Dependencies

For details on using this tab, see Working with Object Dependencies.

Privileges

For details on using this tab, see Working with Privileges and Permissions.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.