4.168 DBA_COMPARISON

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

See Also:

"USER_COMPARISON"