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(30) NOT NULL Owner of the comparison
COMPARISON_NAME VARCHAR2(30) 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