返回
-
标题
How to sync a Target table using Oracle Export/Import with FLASHBACK_SCN option and reconcile. -
说明
Starting with Oracle 9i, it is possible to take an Export of a database which is consistent from a specified SCN.This allows for it's use in SharePlex to resync a Target table.Especially when the Source table is constantly being accessed for changes by users.The procedure does involve using the SharePlex Reconcile command.A limitation of this procedure is that the table has to replicate via a dedicated named Post queue.The named Post queue should not hold data for any other table because Reconcile will remove all committed transactions less than or equal to the reconcile SCN-1,regardless of the table it belongs to.