2.226 ALL_MVIEW_LOGS
ALL_MVIEW_LOGS
describes all materialized view logs accessible to the current user.
Related Views
-
DBA_MVIEW_LOGS
describes all materialized view logs in the database. -
USER_MVIEW_LOGS
describes all materialized view logs owned by the current user.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
|
Owner of the materialized view log |
|
|
|
Name of the master table or master materialized view whose changes are logged |
|
|
|
Name of the table where the changes to the master table or master materialized view are logged |
|
|
|
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. |
|
|
|
Indicates whether rowid information is recorded ( |
|
|
|
Indicates whether primary key information is recorded ( |
|
|
|
Indicates whether object identifier information in an object table is recorded ( |
|
|
|
Indicates whether filter column information is recorded ( |
|
|
|
Indicates whether the sequence value, which provides additional ordering information, is recorded ( |
|
|
|
Indicates whether both old and new values are recorded ( |
|
|
|
Indicates whether the materialized view log is purged asynchronously ( |
|
|
|
Indicates whether the materialized view log is purged in a deferred manner ( |
|
|
|
For deferred purge, the purge start date |
|
|
|
For deferred purge, the purge interval |
|
|
|
Date of the last purge |
|
|
|
Status of the last purge (error code or |
|
|
|
Number of rows purged in the last purge |
|
|
|
Indicates whether the materialized view log is commit SCN-based ( |
|
|
|
Indicates whether the materialized view log is a staging log for synchronous refresh ( |
See Also: