Note
This view is introduced since OceanBase Database V4.3.0.
Purpose
The ALL_MVIEW_LOGS view displays information about all materialized view logs.
Columns
| Column | Type | Nullable? | Description |
|---|---|---|---|
| LOG_OWNER | VARCHAR2(128) | YES | The owner of the materialized view log. |
| MASTER | VARCHAR2(128) | YES | The name of the master table to which the materialized view log belongs. |
| LOG_TABLE | VARCHAR2(128) | YES | The name of the materialized view log table. |
| LOG_TRIGGER | VARCHAR2(128) | YES | The AFTER row trigger on the master table for inserting rows into the materialized view log.
NoteThis column is used only for compatibility and is |
| ROWIDS | VARCHAR2(3) | NO | Indicates whether ROWIDs are recorded. Valid values:
|
| PRIMARY_KEY | VARCHAR2(3) | NO | Indicates whether the primary key is recorded. Valid values:
|
| OBJECT_ID | VARCHAR2(3) | NO | Indicates whether object IDs are recorded in the object table. Valid values:
NoteThis column is used only for compatibility and is |
| FILTER_COLUMNS | VARCHAR2(3) | NO | Indicates whether filter columns are recorded. Valid values:
|
| SEQUENCE | VARCHAR2(3) | NO | Indicates whether sequence values that provide additional sorting information are recorded. Valid values:
NoteAt present, the value of this column is fixed to |
| INCLUDE_NEW_VALUES | VARCHAR2(3) | NO | Indicates whether both old values and new values are recorded. Valid values:
NoteAt present, the value of this column is fixed to |
| PURGE_ASYNCHRONOUS | VARCHAR2(3) | NO | Indicates whether the materialized view log is asynchronously purged. Valid values:
|
| PURGE_DEFERRED | VARCHAR2(3) | NO | Indicates whether the materialized view log is purged after a delay. Valid values:
|
| PURGE_START | DATE | YES | The date when the purge starts. |
| PURGE_INTERVAL | VARCHAR2(200) | YES | The interval for purging. |
| LAST_PURGE_DATE | DATE | YES | The date when the materialized view log was last purged. |
| LAST_PURG_ESTATUS | NUMBER | NO | The status of the last purge of the materialized view log.
NoteAt present, the value of this column is fixed to |
| NUM_ROWS_PURGED | NUMBER | YES | The number of rows purged in the last purge of the materialized view log. |
| COMMIT_SCN_BASED | VARCHAR2(3) | NO | Indicates whether the materialized view log was committed based on the SCN. Valid values:
NoteAt present, the value of this column is fixed to |
| STAGING_LOG | VARCHAR2(3) | NO | Indicates whether the materialized view log is a temporary log that is synchronously refreshed. Valid values:
NoteThis column is used only for compatibility and is |
Sample query
obclient [SYS]> SELECT * FROM SYS.ALL_MVIEW_LOGS WHERE ROWNUM < = 1;
The query result is as follows:
+-----------+--------+------------+-------------+--------+-------------+-----------+----------------+----------+--------------------+--------------------+----------------+-------------+----------------+-----------------+-------------------+-----------------+------------------+-------------+
| 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 |
+-----------+--------+------------+-------------+--------+-------------+-----------+----------------+----------+--------------------+--------------------+----------------+-------------+----------------+-----------------+-------------------+-----------------+------------------+-------------+
| SYS | TBL3 | MLOG$_TBL3 | NULL | NO | YES | NO | YES | YES | YES | NO | NO | NULL | NULL | 20-JAN-24 | 0 | 0 | YES | NO |
+-----------+--------+------------+-------------+--------+-------------+-----------+----------------+----------+--------------------+--------------------+----------------+-------------+----------------+-----------------+-------------------+-----------------+------------------+-------------+
1 row in set (0.021 sec)