Need to replicate 3 tables from Oracle database

Posted on 2014-08-01
Last Modified: 2014-08-18
I'm looking for a solution that will replicate 3 tables from Oracle 11g database A to a different Oracle database B in real time if possible, if not then as often as possible.
Question by:NytroZ
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Goldengate is the 'new' product Oracle is pushing.

    If you are running Enterprise Edition, Streams Replication is free but it is deprecated in 12c and may go away after that.

    Then there is the older Multi-Master replication.

    The online docs talk about all of these.
    LVL 73

    Accepted Solution

    realtime option 1 would be to use views that query across a database link.

    Your queries on B would be slower though because they'd have to pull the data across the link; but the data would always be realtime accurate.

    realtime option 2 are triggers on the tables in A that push changes to B as they happen.  Your DML on A will be slower because each row inserted, updated or deleted will have to push the change to B and apply commits across the link.  If for some reason B can't be reached then A can't be updated.

    near-realtime option 1 would be a materialized view that queries the data and refreshes in small window (every few minutes)

    near-realtime option 2 would be a stored procedure and schedule that refreshes the data for you - if the tables are small this might be viable, if large then materialized views will likely be easier

    near-realtime option 3 would be external tools

    Author Comment

    We are using Oracle Standard Edition One.  I was hoping someone could recommend a third party tool that we could use and controle since we don't have an Oracle dba in house to write queries or stored procedures.
    LVL 76

    Expert Comment

    by:slightwv (䄆 Netminder)
    Standard One comes with 'Basic Replication'.

    Now the bad news:  I cannot find anything that tells me what 'basic replication' means.

    You might want to contact Oracle Support for clarification.
    LVL 13

    Expert Comment

    by:Alexander Eßer [Alex140181]
    I agree with slightwv about "Basic Replication" in SE/SE1. In my opinion there is actually no (legal) way to use built-in Oracle replication tools unless you go for EE ;-)

    I mentioned this one in various threads, so I will now: try this tool (eval) for yourself BEFORE even thinking about buying Golden Gate ;-)

    Its cost are VERY low and -speaking for myself- it's far less complicated than Golden Gate...

    Author Closing Comment

    I found a third party tool from Double Take that we are currently testing.

    Featured Post

    Looking for New Ways to Advertise?

    Engage with tech pros in our community with native advertising, as a Vendor Expert, and more.

    Join & Write a Comment

    Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
    Note: this article covers simple compression. Oracle introduced in version 11g release 2 a new feature called Advanced Compression which is not covered here. General principle of Oracle compression Oracle compression is a way of reducing the d…
    Via a live example, show how to take different types of Oracle backups using RMAN.
    This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now