Skip Headers

Oracle9i Database Reference
Release 2 (9.2)

Part Number A96536-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Feedback

Go to previous page Go to next page
View PDF

ALL_MVIEW_DETAIL_RELATIONS

ALL_MVIEW_DETAIL_RELATIONS describes the named detail relations that are either specified in the FROM list of the subquery that defines a materialized view accessible to the current user, or that are indirectly referenced through views in that FROM list. Inline views in the materialized view definition are not represented in this view or the related views.

Related Views

All three views exclude materialized views that reference remote tables or that includes references to a nonstatic value such as SYSDATE or USER. These views also exclude materialized views that were created as snapshots prior to Oracle8i and that were never altered to enable query rewrite.

Column Datatype NULL Description

OWNER

VARCHAR2(30)

NOT NULL

Owner of the materialized view

MVIEW_NAME

VARCHAR2(30)

NOT NULL

Name of the materialized view

DETAILOBJ_OWNER

VARCHAR2(30)

NOT NULL

Detail object owner

DETAILOBJ_NAME

VARCHAR2(30)

NOT NULL

Detail object name (that is, the name of a table or view)

DETAILOBJ_TYPE

VARCHAR2(9)

TABLE, VIEW, SNAPSHOT, CONTAINER, or UNDEFINED

DETAILOBJ_ALIAS

VARCHAR2(30)

Implicit or explicit alias for detail relation