Skip Headers
Oracle® Database Reference
11g Release 2 (11.2)

Part Number E10820-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
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

ALL_MVIEW_LOGS

ALL_MVIEW_LOGS describes all materialized view logs accessible to the current user.

Related Views

Column Datatype NULL Description
LOG_OWNER VARCHAR2(30)   Owner of the materialized view log
MASTER VARCHAR2(30)   Name of the master table or master materialized view whose changes are logged
LOG_TABLE VARCHAR2(30)   Name of the table where the changes to the master table or master materialized view are logged
LOG_TRIGGER VARCHAR2(30)   Obsolete with Oracle8i and later. Set to NULL. Formerly, this parameter was an after-row trigger on the master which inserted rows into the log.
ROWIDS VARCHAR2(3)   Indicates whether rowid information is recorded (YES) or not (NO)
PRIMARY_KEY VARCHAR2(3)   Indicates whether primary key information is recorded (YES) or not (NO)
OBJECT_ID VARCHAR2(3)   Indicates whether object identifier information in an object table is recorded (YES) or not (NO)
FILTER_COLUMNS VARCHAR2(3)   Indicates whether filter column information is recorded (YES) or not (NO)
SEQUENCE VARCHAR2(3)   Indicates whether the sequence value, which provides additional ordering information, is recorded (YES) or not (NO)
INCLUDE_NEW_VALUES VARCHAR2(3)   Indicates whether both old and new values are recorded (YES) or old values are recorded but new values are not recorded (NO)
PURGE_ASYNCHRONOUS VARCHAR2(3)   Indicates whether the materialized view log is purged asynchronously (YES) or not (NO)
PURGE_DEFERRED VARCHAR2(3)   Indicates whether the materialized view log is purged in a deferred manner (YES) or not (NO)
PURGE_START DATE   For deferred purge, the purge start date
PURGE_INTERVAL VARCHAR2(200)   For deferred purge, the purge interval
LAST_PURGE_DATE DATE   Date of the last purge
LAST_PURGE_STATUS NUMBER   Status of the last purge (error code or 0 for success)
NUM_ROWS_PURGED NUMBER   Number of rows purged in the last purge
COMMIT_SCN_BASED VARCHAR2(3)   Indicates whether the materialized view log is commit SCN-based (YES) or not (NO)