4.170 DBA_COMPARISON_ROW_DIF

DBA_COMPARISON_ROW_DIF displays information about the differing rows in all comparison scans in the database.

Related View

USER_COMPARISON_ROW_DIF displays information about the differing rows in the comparison scans 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

SCAN_ID

NUMBER

NOT NULL

Scan ID for the comparison scan

LOCAL_ROWID

ROWID

Local rowid of the differing row

REMOTE_ROWID

ROWID

Remote rowid of the differing row

INDEX_VALUE

VARCHAR2(4000)

Index column value of the differing row

STATUS

VARCHAR2(3)

Status of the differing row:

  • SUC

  • DIF

LAST_UPDATE_TIME

TIMESTAMP(6)

Time that this row was last updated