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!

Error handling for delete

ARUN-AMay 31 2016 — edited Jun 1 2016

Hi Experts,

Is there any option to use REPERROR parameter only for DELETE operation on targets side.

We have scenario like, if delete comes from source that time we need to handle like ,,

if the particular record exist in target table then that should be deleted. if data dose not exist then that should be ignored, this must be only for DELETE operation and only for one table.

if we use REPERROR(1403, IGNORE) --- this parameter ignore the no data found error for UPDATE operation as well but that should not be ignored for UPDATE .

can you please suggest , this option required for only one table,?

Thanks,

Arun

This post has been answered by K.Gan on Jun 1 2016

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 29 2016

Added on May 31 2016

#goldengate

10 comments

2,280 views