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.