Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback, please email oracle-forums_moderators_us@oracle.com

ResolveConflicts

Renan BarbalhoJan 31 2017 — edited Feb 1 2017

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

This post has been answered by Renan Barbalho on Feb 1 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Mar 1 2017
Added on Jan 31 2017
3 comments
376 views