IBM Support

IBM Infoshpere CDC for Oracle replication: How to synchronize tables manually by DataPump, when iReflect is synchronizing

Troubleshooting


Problem

If you try to synchronize tables manually by DataPump, synchronization will stop abnormally, when iReflect is syncronizing

Symptom

You can find errors about the table "SYS_IMPORT/EXPORT_TABLE_xx" in event logs.
The detailed messages maybe various due to the sequence & stop time point of the export/import actions.

Cause

The table "SYS_IMPORT/EXPORT_TABLE_xx" is a temporary table created by Oracle database when doing data import or export by DataPump. It will be removed after DataPump finishes.

When customer uses iReflect to synchronize all the tables in the schema, iReflect will also synchronize this temporary table between the primary and secondary databases.

The actions of "export from primary database" and "import into target database" will cause out-of-sync status in iReflect, because the temporary tables are created then removed by Oracle automatically.

Resolving The Problem

Please exclude "SYS_IMPORT_TABLE*" with "ALL_TYPES" in the Object Specifiers.

[{"Product":{"code":"SS6HD6","label":"InfoSphere Change Data Capture for Oracle Replication"},"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Component":"--","Platform":[{"code":"PF016","label":"Linux"},{"code":"PF027","label":"Solaris"},{"code":"PF002","label":"AIX"},{"code":"PF010","label":"HP-UX"}],"Version":"3.1","Edition":"All Editions","Line of Business":{"code":"LOB10","label":"Data and AI"}}]

Document Information

Modified date:
16 June 2018

UID

swg21503033

Page Feedback