Is it possible to repair or compare a table from a given SCN onwards?
It is possible for SharePlex to do selective compare/repair of the table. Though the SCN cannot be specified, you can use indirect means to compare/repair a table after a SCN, subject to certain conditions. You can use the function scn_to_timestamp to get the time associated with that SCN. If the table has a column like UPDATE_DATE which gets populated with a value the first time a row is created and also gets populated when the row is subsequently updated, then you can also use the “where” clause to your advantage and repair only those rows that were created or updated after a particular time. For example, if the time corresponding to that SCN is, say, October 18, 2016, then you can formulate the following Repair command to repair only those rows that were created or updated after October 18, 2016:
repair owner.source_table where "UPDATE_DATE > to_date('18-OCT-16', 'DD-MON-RR')"
Although we have simplified the date value and specified the date without any components of hours, minutes or seconds, etc, it is possible to specify the precise time associated with that SCN in the “where” clause.
For DELETEs this question is irrelevant as the row does not exist on target once DELETE happened at whatever time in the past. So even if you query the source table for a row from a time in the past, now that the row has been deleted, it will not show up in that query.
The command will also work for compare.
