GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to instruct Replicat to skip error "ORA-01435 " only when the transaction is an UPDATE

User_LYGSLMar 11 2014 — edited Mar 19 2014

Source and Target : Oracle DB 11g , GG 11g

In source somehow from the application a wrong value for date field is being updated and when this record comes to target , the replicat is abending due to error ORA-01435 : not a valid month. What we have osbserved is , after a while the correct date is updated for sure .

So , on the target side i want replicat to continue processing without abending when this error is encountered but only when the SQL is an UPDATE statement and only for 1 specific table .

Any pointers is much appreciated .

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 16 2014

Added on Mar 11 2014

#goldengate

11 comments

711 views