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

本站中文解释

Oracle视图ALL_REFRESH_CHILDREN用于查询与指定分区表（复制和/或分区）关联的引用控制列表（RCL）的儿童表。

用法：SELECT child_name FROM ALL_REFRESH_CHILDREN WHERE owner = owner_name AND name = table_name

它可以用于列出拥有着所有特定表的用户有关此表的更新模型和更新级别。它还可以被用来查询是否为此表设置了更新策略。

官方英文解释

ALL_REFRESH_CHILDREN describes all the objects in refresh groups that are accessible to the current user.

Related Views

DBA_REFRESH_CHILDREN describes the objects in all refresh groups in the database.

USER_REFRESH_CHILDREN describes the objects in all refresh groups owned by the current user.

Indicates whether the refresh group is destroyed when its last item is subtracted (Y) or not (N)

Indicates whether changes are pushed from the snapshot to the master before refresh (Y) or not (N)

Indicates whether to proceed with refresh despite errors when pushing deferred RPCs (Y) or not (N)

Method for purging the transaction queue after each push. 1 indicates quick purge option; 2 indicates precise purge option

我想要获取技术服务或软件
服务范围：MySQL、ORACLE、SQLSERVER、MongoDB、PostgreSQL 、程序问题
服务方式：远程服务、电话支持、现场服务，沟通指定方式服务
技术标签：数据恢复、安装配置、数据迁移、集群容灾、异常处理、其它问题

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