Physical Modeling › Oracle Physical Property Editors › Oracle Materialized View Editor › Oracle Materialized View Editor - Refresh Tab

Oracle Materialized View Editor - Refresh Tab

Use the Refresh tab to select the refresh options for a materialized view. The following describes the options for this tab:

Refresh Interval

Select this check box to select one of the following options:

ON DEMAND

ON COMMIT

NEVER

If you select NEVER, the other options for this tab are disabled.

Start Date

Specify a date expression for the first automatic refresh time.

Next Date

Specify a date expression for calculating the interval between automatic refreshes.

Refresh Type

Select one of the following options:

FAST

Performs the refresh according to the changes that have occurred to the master tables.

COMPLETE

A COMPLETE refresh is implemented by executing the materialized view's defining subquery.

FORCE

When a refresh occurs, Oracle performs a FAST refresh if one is possible, or it performs a COMPLETE refresh otherwise.

Refresh Method

Select one of the following options:

PRIMARY KEY

Create a Primary Key materialized view.

ROWID

Create a rowid materialized view.

Local Rollback

Select this check box to use a local rollback segment during the materialized view refresh. Select one of the following options:

DEFAULT

Uses the default local rollback segment.

Specify

Select this option to specify a local rollback segment other than the default. Select the name of the local rollback from the drop-down list. Click the button to open the Oracle Rollback Segment Editor if you want to edit any properties of the rollback segment.

Master Rollback

Select this check box to use a master rollback segment during the materialized view refresh. Select one of the following options for Master Rollback:

DEFAULT

Uses the default master rollback segment.

Specify

Select this option to specify a master rollback segment other than the default. Select the name of the master rollback from the drop-down list. Click the button to open the Oracle Rollback Segment Editor if you want to edit any properties of the rollback segment.

Constraint Type

Select one of the following options:

ENFORCED

TRUSTED