We are using Oracle Database 11g Enterprise Edition Release 220.127.116.11.0 version. I am getting conflict error when I try to merge child workspace to parent. so i executed the following statements to resolve the conflict
EXECUTE DBMS_WM.BeginResolve ('PREVIOUS');
EXECUTE DBMS_WM.ResolveConflicts ('PREVIOUS', 'table name', 'table _primary_key = 11865109', 'child');
EXECUTE DBMS_WM.CommitResolve ('PREVIOUS');
and i getting thwe following error
EXECUTE DBMS_WM.ResolveConflicts ('PREVIOUS', 'table name', 'table _primary_key = 11865109', 'child');Error report -
ORA-29875: failed in the execution of the ODCIINDEXINSERT routine
ORA-20232: unique constraint (MGFEE.MI_34_IDXB$) violated
ORA-06512: at "MGFEE.OVM_INSERT_782", line 4
ORA-04088: error during execution of trigger 'MGFEE.OVM_INSERT_782'
ORA-06512: at "WMSYS.LT", line 8588
ORA-06512: at line 1
29875. 00000 - "failed in the execution of the ODCIINDEXINSERT routine"
*Cause: Failed to successfully execute the ODCIIndexInsert routine.
*Action: Check to see if the routine has been coded correctly.
Could you please advise how to fix this issue. Thanks for your help.
What is the definition of the MI_34_IDXB$ unique constraint? Also, query the table_name_conf view for table _primary_key = 11865109 and post the results, if possible.