Forum Discussion

apitcher11's avatar
apitcher11
Regular Visitor
6 months ago

Oracle Mirroring - Invalid Identifier Error

I am trying to mirror from an on-prem Oracle DB, and one of the tables I need gives me the following error: SourceErrorCode: ReplicationError: Failed to do initial data load for table <TableName> ...
Need Help
Lozovskyi's avatar
Lozovskyi
Icon for Kudo Collector rankKudo Collector
4 months ago

Hello apitcher11 , unfortunatelly it is a delta table limitation. Even in copy activity you might have the same issue, so the only way to overcome it is to have custom configuration-driven copy pipeline, where you explicitely define DML and rename this column to _.

Thank you for sharing the case. Hopefully we'll get mirroring setup upgrade in the near future.

 

BR, Taras