<< Click to Display Table of Contents >>

Introduction

Top Previous Next

This page provides an interface for viewing and managing materialized views (snapshots) in the current schema. Materialized views combine columns from database tables into actual database objects, and can be updated as the contents of the underlying tables change.

Hora's interface consists of the following overlapping sheets:

Query

Shows the query used to construct the view.

Detail Relations

Shows the detail tables associated with the view, from ALL_MVIEW_DETAIL_RELATIONS.

Joins

Shows the columns and operators used to join the tables.

Keys

Lists the columns in the materialized view, if any.

Aggregates

Lists the aggregates in the materialized view, if any.

Audit

Shows the current state of auditing against the materialized view.