一起学习网 一起学习网


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

网络编程 Oracle 视图 DBA_COMPARISON 官方解释,作用,如何使用详细说明 10-19

本站中文解释

字典视图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.

ColumnDatatypeNULLDescription

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

See Also:

“USER_COMPARISON”


编辑:一起学习网

标签:视图,数据,模式,信息,英文