Skip Headers
Oracle® Database Reference
11g Release 1 (11.1)

Part Number B28320-01
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

DBA_COMPARISON_ROW_DIF

DBA_COMPARISON_ROW_DIF provides details about differing rows in all comparison scans in the database.

Related View

USER_COMPARISON_ROW_DIF provides details about differing rows in all comparison scans owned by the current user. This view does not have 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 or DIF
LAST_UPDATE_TIME TIMESTAMP(6)   The time that this row was last updated