Q
Problem solve Get help with specific problems with your technologies, process and projects.

Joining data from different locations in one server

I have two production servers in different locations, and data will be updated daily in both. I need join both server's data in one server. I used the IMP/EXP commands but did not got good result. How can I join the data without any loss?

It sounds like Oracle's Replication Services is what you need. With Replication Services, you can have data duplicated in another database without loss of data. This product does have an extra cost, but it works well for your solution.

You can make your own replication by using database triggers and moving data through database links. This can be a lot of work though.


Dig Deeper on Oracle database backup and recovery

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close