Dimension Property Sheet: Materialized View tab

Dimension materialized views support automatic refresh of dimension members, levels, hierarchies, and attributes.

Enable Materialized View Refresh of the Dimension

Select this option to refresh of the dimension members automatically by using the database materialized view refresh system. This method of refreshing a dimension is an alternative to a manual refresh. You can enable and disable refresh without losing the other settings.

Refresh Mode

Choose one of the following refresh modes:

• On Demand: Waits for you to initiate a refresh manually.
• On Commit: Initiates a fast refresh whenever the database commits a transaction that changes the source table.
• Start/Next: Uses the expressions displayed in the Start With and Next Refresh boxes to schedule refreshes.

Start With:

Displays the expression for scheduling the first refresh using the Start/Next method. Typically, this expression identifies a single date and time for the initial refresh.

Next Refresh:

Displays the expression for scheduling the additional refreshes using the Start/Next refresh mode. Typically, this expression identifies an interval for scheduling routine periodic refreshes.

Modify

Displays the Set Refresh Times dialog box for setting the Start With and Next Refresh expressions.

Constraints

Controls the types of constraints that are used during a refresh:

• Trusted: Use both enforced or unenforced constraints.
• Enforced: Use only enforced constraints.

The Refresh and Rewrite tabs display status information about the materialized views.

• Refresh: Displays information about the status of automatic refresh.

  • Compatibility Check List: Identifies the types of checks made for materialized views and the result of the tests. The related objects may have characteristics that are incompatible with the creation of a materialized view.

    • Status: The success or failure of the object to pass the checks.

    • Object: Lists the master tables involved in a refresh.

    • Check: The criteria for creating a refresh materialized view.

  • Materialized View Details: Describes the materialized view as currently defined.

    • Name: Lists characteristics of a refresh materialized view.

    • Value: Identifies the value or current status of each characteristic.

• Rewrite: Displays information about the status of query rewrite. The Rewrite tab displays the same type of reports as Refresh, but the details are different.

Related Topics

Creating Materialized Views

Copyright © 2003, 2007, Oracle. All rights reserved.