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_CHILDRENdescribes the objects in all refresh groups in the database. -
USER_REFRESH_CHILDRENdescribes the objects in all refresh groups owned by the current user.
| Column | Datatype | NULL | Description |
|---|---|---|---|
|
|
|
|
Owner of the object in the refresh group |
|
|
|
|
Name of the object in the refresh group |
|
|
|
Type of the object in the refresh group |
|
|
|
|
|
Owner of the refresh group |
|
|
|
|
Name of the refresh group |
|
|
|
Internal identifier of the refresh group |
|
|
|
|
Indicates whether the refresh group is destroyed when its last item is subtracted ( |
|
|
|
|
Indicates whether changes are pushed from the snapshot to the master before refresh ( |
|
|
|
|
Indicates whether to proceed with refresh despite errors when pushing deferred RPCs ( |
|
|
|
|
Name of the rollback segment to use while refreshing |
|
|
|
|
Identifier of the job used to refresh the group automatically |
|
|
|
|
Date that this job will next be refreshed automatically, if not broken |
|
|
|
|
A date function used to compute the next |
|
|
|
|
Indicates whether the job is broken and will never be run ( |
|
|
|
|
Method for purging the transaction queue after each push. |
|
|
|
|
Level of parallelism for transaction propagation |
|
|
|
|
Size of the heap |
|
|
|
|
The name of the job used to automatically refresh the group |
See Also:
-
“DBA_REFRESH_CHILDREN”
-
“USER_REFRESH_CHILDREN”
