Hi folks,
I have a problem.
I have a database working with workspace manager. This database was divide this way:
- LIVE
+ RENAN_WKS
+ PABLO_WKS
I had have a conflict in workspace RENAN_WKS because the client modified a row that was excluded in LIVE.
I solved the conflict this way:
call DBMS_WM.BeginResolve('RENAN_WKS');
call DBMS_WM.ResolveConflicts('RENAN_WKS','BAIRRO_FISCAL','BAIRCOD = 950','parent');
commit;
call DBMS_WM.CommitResolve('RENAN_WKS');
I checked all workspaces and all are OK.
My database has the table BAIRRO_FISCAL, this way:
BAIRRO_FISCAL
BAIRCOD NUMBER
BAIRNOME VARCHAR2(100)
GEOM SDO_GEOMETRY
I understood that one time that a conflict fixed is possible return to work then the client of workspace RENAN_WKS inserted on database the record with same ID that was excluded on workspace LIVE and solved conflict. But when I'll Merge the workspaces the conflicts returns.
Why this happening?
I forgot any step in resolve conflicts steps?
Regards,
Renan