[Home] [Help] [Dependency Information]
Object Name: | USER_COMPARISON_ROW_DIF |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Details about the differing rows in a comparison scan
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
COMPARISON_NAME | VARCHAR2 | (128) | Yes | Name of comparison |
SCAN_ID | NUMBER | Yes | Scan id of scan | |
LOCAL_ROWID | ROWID | (10) | Local rowid of differing row | |
REMOTE_ROWID | ROWID | (10) | Remote rowid of differing row | |
INDEX_VALUE | VARCHAR2 | (4000) | Index column value of differing row | |
STATUS | VARCHAR2 | (3) | Status of differing row: SUC or DIF | |
LAST_UPDATE_TIME | TIMESTAMP(6) | (11) | The time that this row was updated |
Cut, paste (and edit) the following text to query this object:
SELECT COMPARISON_NAME
, SCAN_ID
, LOCAL_ROWID
, REMOTE_ROWID
, INDEX_VALUE
, STATUS
, LAST_UPDATE_TIME
FROM SYS.USER_COMPARISON_ROW_DIF;
|
|
|