Oracle教程 2023-04-08

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`	`VARCHAR2(128)`	`NOT NULL`	Owner of the comparison
`COMPARISON_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the comparison
`COMPARISON_MODE`	`VARCHAR2(5)`		Mode of the comparison: `TABLE`
`SCHEMA_NAME`	`VARCHAR2(128)`		Schema name of the local object
`OBJECT_NAME`	`VARCHAR2(128)`		Name of the local object
`OBJECT_TYPE`	`VARCHAR2(17)`		Type of the local object: `TABLE` `VIEW` `SYNONYM` `MATERIALIZED VIEW`
`REMOTE_SCHEMA_NAME`	`VARCHAR2(128)`		Schema name of the remote object
`REMOTE_OBJECT_NAME`	`VARCHAR2(128)`		Name of the remote object
`REMOTE_OBJECT_TYPE`	`VARCHAR2(17)`		Type of the remote object: `TABLE` `VIEW` `SYNONYM` `MATERIALIZED VIEW`
`DBLINK_NAME`	`VARCHAR2(128)`		Database link name to the remote database
`SCAN_MODE`	`VARCHAR2(9)`		Scan mode of the comparison: FULL `FULL` `RANDOM` `CYCLIC` `CUSTOM`
`SCAN_PERCENT`	`NUMBER`		Scan percent of the comparison; applicable to random and cyclic modes
`CYCLIC_INDEX_VALUE`	`VARCHAR2(4000)`		Last index column value used in a cyclic scan
`NULL_VALUE`	`VARCHAR2(4000)`		Value to use for NULL columns
`LOCAL_CONVERGE_TAG`	`RAW(2000)`		Local Replication tag used while performing converge DMLs
`REMOTE_CONVERGE_TAG`	`RAW(2000)`		Remote Replication tag used while performing converge DMLs
`MAX_NUM_BUCKETS`	`NUMBER`		Suggested maximum number of buckets in a scan
`MIN_ROWS_IN_BUCKET`	`NUMBER`		Suggested minimum number of rows in a bucket
`LAST_UPDATE_TIME`	`TIMESTAMP(6)`		Time that this row was last updated