GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Which type of Replication is it called ??

edited Jul 10, 2014 3:36PM in GoldenGate, Streams and Distributed Database (MOSC) 5 commentsAnswered ✓

Hi

I had prepared two environments for data replication.

Both have the same database structure but with different DB Names.

I need only to replicate two tables between the databases. One table is users, which have user ID as a primary key. The second table is userImg, which is referencing the userid image.

From the first site , it should store user IDs from 1 to 10000 , where the second site it should start storing user ids from 10001 till 20000.

I need to know which type of replication that I should use to replicate from site A the userID and its references in table userImgs from 1-10000 to Site B , at the same time Site B should replicate the same from userID 10001, so almost the two sites have almost the same data ?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center