| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
| Oracle® Database Reference 11g Release 1 (11.1) Part Number B28320-01 |
|
|
View PDF |
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 |
