Need to replicate 3 tables from Oracle database

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.
NytroZAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

slightwv (䄆 Netminder) Commented:
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.
0
sdstuberCommented:
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
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
NytroZAuthor Commented:
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.
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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

http://www.oracle.com/us/products/database/enterprise-edition/comparisons/index.html

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

You might want to contact Oracle Support for clarification.
0
Alexander Eßer [Alex140181]Software DeveloperCommented:
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 ;-)
http://www.dbvisit.com/products/dbvisit_replicate_real_time_oracle_database_replication/

Its cost are VERY low and -speaking for myself- it's far less complicated than Golden Gate...
0
NytroZAuthor Commented:
I found a third party tool from Double Take that we are currently testing.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Oracle Database

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.