Answer the question
In order to leave comments, you need to log in
How to overwrite an entry in Golden Gate if it exists?
Good afternoon, please tell me with the following question,
In Oracle Golden Gate, you need to handle an error using RESOLVECONFLICT, for example, I'm trying to insert a row whose value in one of the columns is 100 or 101, it already exists and needs to be overwritten or skipped if already exists, I found the processing of the column
in the instruction , but how can I process not the whole column, but process if it has a certain value?
I tried to add the following to the EXT group (./ggsci edit params ext1):
MAP TABLE.src, TARGET TABLE.trg,
COMPARECOLS
(ON UPDATE ALLEXCLUDING (column)),
RESOLVECONFLICT (INSERTROWEXISTS, (DEFAULT, OVERWRITE (column)),
RESOLVECONFLICT (UPDATEROWMISSING, (DEFAULT, OVERWRITE (column))),
);
Answer the question
In order to leave comments, you need to log in
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question