For a row in an Oracle table – if I read the ORA_ROWSCN
now and store it then moments (or days) later read the ORA_ROWSCN
and it is the same, can I safely know that the row has not changed?
PSUDO CODE:
remote = PK, ORA_ROWSCN FROM Oracle
local = PK, stored_scn FROM local store
new records = remote PK not in local PK
deleted records = local PK not in remote PK
changed records = local PK = remote PK AND local stored_scn != remote ORA_ROWSCN