Oracle 视图 DBA_COMPARISON 官方解释,作用,如何使用详细说明
本站中文解释
字典视图DBA_COMPARISON显示当前用户在“数据对比”会话中的所有模式的参数设置,它也支持有关可比较的拒绝列表,表比较,视图比较和索引比较的信息。
使用Oracle视图DBA_COMPARISON的最佳实践是下载当前的数据,为某些模式应用参数,使用会话ID引用以前的会话和下载已完成的会话信息。用户可以评估数据对比以建立其本身的对比策略。
官方英文解释
DBA_COMPARISON
displays information about all comparison objects in the database.
Related View
USER_COMPARISON
displays information about the comparison objects owned by the current user. This view does not display the OWNER
column.
Column | Datatype | NULL | Description |
---|---|---|---|
|
|
| Owner of the comparison |
|
|
| Name of the comparison |
|
| Mode of the comparison:
| |
|
| Schema name of the local object | |
|
| Name of the local object | |
|
| Type of the local object:
| |
|
| Schema name of the remote object | |
|
| Name of the remote object | |
|
| Type of the remote object:
| |
|
| Database link name to the remote database | |
|
| Scan mode of the comparison: FULL
| |
|
| Scan percent of the comparison; applicable to random and cyclic modes | |
|
| Last index column value used in a cyclic scan | |
|
| Value to use for NULL columns | |
|
| Local Replication tag used while performing converge DMLs | |
|
| Remote Replication tag used while performing converge DMLs | |
|
| Suggested maximum number of buckets in a scan | |
|
| Suggested minimum number of rows in a bucket | |
|
| Time that this row was last updated |
See Also:
“USER_COMPARISON”
编辑:一起学习网
标签:视图,数据,模式,信息,英文