[Home] [Help] [Dependency Information]
Object Name: | USER_MVIEW_LOGS |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
All materialized view logs owned by the user
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
LOG_OWNER | VARCHAR2 | (128) | Owner of the materialized view log | |
MASTER | VARCHAR2 | (128) | Name of the master table which changes are logged | |
LOG_TABLE | VARCHAR2 | (128) | Log table; with rowids and timestamps of rows which changed in the master | |
LOG_TRIGGER | VARCHAR2 | (128) | Trigger on master table; fills the materialized view log | |
ROWIDS | VARCHAR2 | (3) | If YES, the materialized view log records rowid information | |
PRIMARY_KEY | VARCHAR2 | (3) | If YES, the materialized view log records primary key information | |
OBJECT_ID | VARCHAR2 | (3) | If YES, the materialized view log records object id information | |
FILTER_COLUMNS | VARCHAR2 | (3) | If YES, the materialized view log records filter column information | |
SEQUENCE | VARCHAR2 | (3) | If YES, the materialized view log records sequence information | |
INCLUDE_NEW_VALUES | VARCHAR2 | (3) | If YES, the materialized view log records old and new values (else only old values) | |
PURGE_ASYNCHRONOUS | VARCHAR2 | (3) | If YES, the materialized view log is purged asynchronously | |
PURGE_DEFERRED | VARCHAR2 | (3) | If YES, the materialized view log is purged in a deferred manner | |
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) | If YES, the materialized view log is commit SCN-based | |
STAGING_LOG | VARCHAR2 | (3) | If YES, the log is a staging log for synchronous refresh |
Cut, paste (and edit) the following text to query this object:
SELECT LOG_OWNER
, MASTER
, LOG_TABLE
, LOG_TRIGGER
, ROWIDS
, PRIMARY_KEY
, OBJECT_ID
, FILTER_COLUMNS
, SEQUENCE
, INCLUDE_NEW_VALUES
, PURGE_ASYNCHRONOUS
, PURGE_DEFERRED
, PURGE_START
, PURGE_INTERVAL
, LAST_PURGE_DATE
, LAST_PURGE_STATUS
, NUM_ROWS_PURGED
, COMMIT_SCN_BASED
, STAGING_LOG
FROM SYS.USER_MVIEW_LOGS;
|
|
|