Skip to Main Content

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!

Help To Understand REPERROR (DEFAULT, TRANSDISCARD) in Conflict Resolution File

Debasis MallickJul 21 2025 — edited Jul 22 2025

Hi Team,

We had a below block in conflict resolution file for table sds_pasv_mstr so could you please help me in which error scenarios replicat process will abend and in which scenario replicat will move forward and write the transaction to discard file.

REPERROR (DEFAULT, TRANSDISCARD)
MAP gg.sds_pasv_mstr TARGET gg.sds_pasv_mstr,
COMPARECOLS (ON UPDATE KEYINCLUDING (modified_at), ON DELETE KEY),
RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, USEMAX (modified_at))),
RESOLVECONFLICT (UPDATEROWEXISTS, (DEFAULT, USEMAX (modified_at))),
RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE)),
RESOLVECONFLICT (DELETEROWMISSING, (DEFAULT, IGNORE));

Sorry to ask you this basic question. I searched in blog and documentation but did not get clarity.

So need experts help.

Thanks,

Debasis

Comments
Post Details
Added on Jul 21 2025
3 comments
96 views