3 Replies Latest reply: Sep 19, 2012 10:56 AM by user4065345 RSS

    mergetable with subquery

    user4065345
      Hi All,

      I'm a bit stuck using the mergetable call with a subquery.

      I manually track user modifications in a non versioned table ; when I try to merge user modifications into 'live', i get the following error:

      ORA-20077: insufficient privileges on the versioned table 'SYSTEM.CLASS'
      ORA-06512: à "WMSYS.LT", ligne 7191
      ORA-06512: à ligne 2


      the merge call is the following:
      BEGIN
      DBMS_WM.MergeTable('WORK', 'class', WHERE=>'id IN(select id from modifications)');
      end;
      /

      As seen, I'm connected as system user to test DBMS_WM package
      The 'class' table is versioned.
      The 'modifications' table is not versioned
      id is the primary key for the 'class' table but not for the 'modifications' table.

      When I change the where clause with some id=xx, the merge is successfull.

      Which privilege can be expected as I'm connected as system ?

      I'm using Oracle 11g R2.

      Thanks for any help,
      Regards,
      --
      Stephane