Materialized Views Editor (Oracle)

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.