Oracle Error ORA-37015: (XSACQUIRE_YNRESYNC) Object workspace object is ambiguously listed to be acquired both with and without RESYNC.

Oracle Error Message

ORA-37015: (XSACQUIRE_YNRESYNC) Object workspace object is ambiguously listed to be acquired both with and without RESYNC.

Reason for the Error

The object is listed in with resync list and no resync list. Such usage is ambiguous as to the user’s intent on preserving or not preserving private changes.

Solution

Do not list the object both with and without RESYNC