0 Replies Latest reply: Feb 29, 2012 8:29 PM by user12100209 RSS

    Oracle Streams apply error at database vault realm

      OS: SLES 11 x86_64 SP1
      Oracle version:

      I have configured an streams replication environment with the downstream database as the destination database where the changes are applied. I have both databases, source and downstream, configured with Oracle Database Vault. My problem is the following:
      When I create a realm to protect the objects in the schema being replicated at the destination database, the dba_apply_error view give me an ora-01031 insufficient privileges. Once I disable the realm the apply process continues working normally.
      The streams administrator user has granted all needed privileges: dv_streams_admin, become user and also has the dba privilege.

      The same environment works fine using the same OS and Oracle Version
      I hope you can help me.
      thanks in advance.