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:
Shows the query used to construct the view.
Shows the detail tables associated with the view, from ALL_MVIEW_DETAIL_RELATIONS.
Shows the columns and operators used to join the tables.
Lists the columns in the materialized view, if any.
Lists the aggregates in the materialized view, if any.
Shows the current state of auditing against the materialized view.