[Home] [Help]
[Dependency Information]
[Home] [Help]
[Dependency Information]
| Object Name: | ALL_MVIEW_LOGS |
|---|---|
| Object Type: | VIEW |
| Owner: | SYS |
| Subobject Name: | |
| Status: | VALID |
All materialized view logs in the database that the user can see
| 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) | An after-row trigger on the master which inserts rows into the 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.ALL_MVIEW_LOGS;
SYS
DBA_MVIEW_LOGS
OBJ$
OBJAUTH$
USER$
PUBLIC
ALL_MVIEW_LOGS
SYS
ALL_BASE_TABLE_MVIEWS
PRVT_PARTREC_NOPRIV
- show dependent code
|
|
|
|