Tuesday, June 12, 2012

ORA-20185: operation disallowed on workspace 'WORKSPACE_NAME' involved in a conflict resolution session.

BEGIN DBMS_WM.removeworkspace('WORKSPACE_NAME'); END;
Error at line 3
ORA-20185: operation disallowed on workspace 'WORKSPACE_NAME' involved in a conflict resolution session
ORA-06512: at "WMSYS.LT", line 4955
ORA-06512: at line 1

Cause:Conflict on workspace.

Action:

SQL> exec dbms_wm.SetConflictWorkspace('WORKSPACE_NAME');

SQL> exec dbms_wm.commitresolve('WORKSPACE_NAME');

SQL> exec DBMS_WM.removeworkspace('WORKSPACE_NAME');

Workspace Removed


Cheers!!!

No comments:

Post a Comment