Oracle 视图 ALL_MVIEW_LOGS 官方解释，作用，如何使用详细说明

本站中文解释

Oracle视图ALL_MVIEW_LOGS用于显示所有受该用户归属的增量迁移视图的注释日志，以及迁移豁免的MV的状态信息。

通过使用本视图可以查看增量迁移视图更新时的日志，便于检测MV的情况。要查看MV更新日志，可以使用 ALL_MVIEW_LOGS 视图，列出 MV_NAME 分区名，状态，更新时间，持续时间，发行表，和更新语句等信息。

举例：

SELECT mv_name,mv_owner,mv_comment,split_part,mapping_table,last_update,update_statement
FROM all_mview_logs
WHERE split_part= SALE AND mv_owner= CURRENT_USER_NAME

官方英文解释

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

Related Views

USER_MVIEW_LOGS describes all materialized view logs owned by the current user.

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 object identifier information in an object table is recorded (YES) or not (NO)

Indicates whether the sequence value, which provides additional ordering information, is recorded (YES) or not (NO)

Indicates whether both old and new values are recorded (YES) or old values are recorded but new values are not recorded (NO)

Indicates whether the materialized view log is purged asynchronously (YES) or not (NO)

Indicates whether the materialized view log is purged in a deferred manner (YES) or not (NO)

Indicates whether the materialized view log is commit SCN-based (YES) or not (NO)

Indicates whether the materialized view log is a staging log for synchronous refresh (YES) or not (NO)

Indicates whether the materialized view log is an automatic materialized view log. Possible values:

YES It is an automatic materialized view log NO It is a user-created materialized view log HYBRID It is a hybrid materialized view log. It was initially a user-created materialized view log and was subsequently altered automatically to include one or more additional columns to support an automatic materialized view.
我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

本站部分文章参考或来源于网络，如有侵权请联系站长。
数据库远程运维 Oracle 视图 ALL_MVIEW_LOGS 官方解释，作用，如何使用详细说明