ORA-00001 and ORA-06512 error on DBMS_WM.ResolveConflicts
882731Aug 16 2011 — edited Aug 24 2011We are getting unique constraint error in Production Database. We are able to merge most of the workspaces with no issues. One workspace is givign errors on merge.
Here is the code
begin
dbms_wm.gotoworkspace('denialletterspoc_onmzpulp');
dbms_wm.setdiffversions('denialletterspoc_onmzpulp','LIVE');
dbms_wm.SetConflictWorkspace('denialletterspoc_onmzpulp');
commit;
DBMS_WM.BeginResolve('denialletterspoc_onmzpulp');
DBMS_WM.ResolveConflicts(
workspace => 'denialletterspoc_onmzpulp',
table_name => 'MCM_MESSAGE',
where_clause => ' id in (8403026,10134822,8259485,8259488,8426289,8426287,10186643,8426288) ',
keep => 'CHILD'
);
exception when others then
DBMS_WM.RollbackResolve('denialletterspoc_onmzpulp');
raise;
end;
ORA-00001: unique constraint (T2.MCM_MESSAGE_PK) violated
ORA-06512: at line 16
I looked at the date in XXX_lt tables and it does not look suspecious. Please help us understand
ORA-00001 and ORA-06512 error.
Amit Gangwar