1 Reply Latest reply: Apr 10, 2014 1:15 PM by mseberg RSS

    Insert into primary database from Active Data Guard standby

    Mimi Miami

      I am using Oracle EE on Solaris 10.


      I have been reading that it is possible to do an insert from my Active Data Guard standby database by redirecting the insert to happen on the primary via a DB link.  I have GLOBAL_NAMES set to TRUE and it needs to stay this way.  This means I cannot create a DB link that points back to my primary as such:




      How can I get around this to be able to insert data into the primary from my ADG standby?