This discussion is archived
3 Replies Latest reply: Sep 19, 2012 8:56 AM by user4065345 RSS

mergetable with subquery

user4065345 Newbie
Currently Being Moderated
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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points