1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Golden Gate; insert, update no reply delete

Discussion in 'Server Administration and Options' started by asencue, Oct 24, 2011.

  1. asencue

    asencue Active Member

    Likes Received:
    Trophy Points:
    Hi everybody,

    I have an architecture with 2 servers Standard Edition Oracle 11gR2.
    In one server i have my online database (6 months) and another server historics (all data).
    I'm thinking which is the best solutions; the first option is Golden Gate but i new in this topic.
    My questions are:
    - Can i install Golden Gate with Oracle Standard??
    - My replication environment is special; In online database only need 6 months (i will delete old data)
    but in historics database i need every data.With Golden Gate, can replicate insert and update but
    no delete?

    Thanks in advance.