Troubleshooting Tips: Index on a replication table present in an alternate schema(other than cdc user schema) results in failure of refresh. (InfoSphere IIG & Unified Governance

The developerWorks Connections platform will be sunset on December 31, 2019. On January 1, 2020, this blog will no longer be available. More details available on our FAQ.

Troubleshooting Tips: Index on a replication table present in an alternate schema(other than cdc user schema) results in failure of refresh.

madavid Visits (4000)

Error messages as follows when you encounter the issue:

error:
A SQL exception has occurr
ed. The SQL error code is '1418'. The SQL state is: 42S12. The
error message is: |[CDC][Oracle JDBC Driver][Oracle]ORA-01418:
specified index does not exist|

Oracle fastload failed.|Oracle fastload failed.|Error in native
code: ORA-26086: direct path does not support triggers

Click the link for the associate technical notes

Tags: cdc

Add a Comment
More Actions v

Comments (0)

Add a Comment

Edit

More Actions v

Quarantine this Entry

Blogs

InfoSphere IIG & Unified Governance - News & Troubleshooting Tips by David Ma

About this blog

Related posts

New Jupyter notebook...

Open your doors to O...

Take advantage of yo...

Deliver real time fe...

Db2 Analytics Accele...

Links

Tags

Troubleshooting Tips: Index on a replication table present in an alternate schema(other than cdc user schema) results in failure of refresh.

Send Email Notification

Quarantine this entry

Mark as Duplicate