4 Replies Latest reply: Feb 24, 2012 5:39 PM by jima RSS

    DBMS_WM.EnableVersioning errors with ORA-20129: table 'AAA' does not exist

    jima
      Running this from a user that is not the table owner, but the user executing the package does have the WM_ADMIN_ROLE. This is running from inside a procedure with AUTHID CURRENT_USER and we run and output "SELECT COUNT(*) FROM AAA;" and see the count right before the EnableVersioining call, so we know the table is there and visible to the executing user.
      OWM_VERSION     9.2.0.1.0 running on 9iR2
      I have granted INSERT, UPDATE, DELETE, SELECT directly to the executing user.
      Anything else I can try?