Geek Answers Handbook

How to synchronize two Oracle databases?

I want to create a project in which I want to synchronize a local database with a remote database. Changes made to the local database must be reflected in the remote database. This must be done synchronously. I have an application that performs CRUD operations in a local database, written in java / jpa. Synchronization should start from java code. I was thinking of triggers in every database table that will support changes to the local database. But I doubt whether it is safe or not. After googling, I found out that the oracle lite database is best suited for synchronizing two databases, but I need to get started quickly. The operating system I use is Windows Xp. The database size is about 2 GB.

I created a thread to achieve the same in java, but from Suggestetion I restarted the same thread in the database context.

+5
source share
3 answers

First of all, I suggest you reconsider your design. The easiest way to replicate your data is through views as suggested in this SO . You can create a DATABASE LINK between your two databases and create views on the remote node that will query the local database. This would be the easiest way to synchronize in real time (less code, less maintenance).

, . . . ON COMMIT REFRESH .

+5

, QA. Oracle, . , .

Navicat Oracle (ab) - . ! ( , .)

+1

, , . - .

, , , , , Oracle Database Lite Mobile Server - , . , Oracle, , . // , . , . ( /... Oracle Mobile Server ). Oracle Mobile Server . , . DBA.

+1
source

More articles:


All Articles