3 Replies Latest reply: Jul 14, 2011 2:41 PM by Ben Speckhard-Oracle RSS

    "ORA-20171 WM error: Insufficient privileges" using mergeTable

    Pedro Lourenço
      Hi,

      I deleted 1 row on a table in a workspace and committed. Now when I do mergeTable for that row I get the following error:

      ORA-20171 WM error: Insufficient privileges
      ORA-06512 at “WMSYS.LT”, line 7203
      ORA-06512 as line 7

      DBMS_WM.mergetable(WORKSPACE => ‘xxxx’,TABLE_ID =>’yyyy’,WHERE_CLAUSE => 'PK_COLUMN = id',REMOVE_DATA => FALSE,AUTO_COMMIT => FALSE);

      The user that i'm using to log in the db has all the available privilieges for all workspaces: XXX_ANY_WORKSPACE; and he is the owner of the refered table.

      Can you help me?
      Thanks in advance.
      Best regards,

      Pedro Lourenço