Synchronizing 2 databases separated by firewall

Ranch Hand

Posts: 884

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I've 2 databases (DB1 & DB2) separated by a firewall. DB1 will push data to DB2 and pull data from DB2 via a nightly job. Is there any feature in Oracle that allows me to ad-hoc-ly push and pull selected records on request in a short time?

SCJP 1.4 * SCWCD 1.4 * SCBCD 1.3 * SCJA 1.0 * TOGAF 8

Jeanne Boyarsky

author & internet detective

Posts: 42173

937

I like...

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Chengwei,
A database replication tool could do this. Or you could write a script and kick it off with a cron job.

[OCP 21 book] | [OCP 17 book] | [OCP 11 book] | [OCA 8 book] [OCP 8 book] [Practice tests book] [Blog] [JavaRanch FAQ] [How To Ask Questions] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2

Java 8 (verified skill)
Skill verified by Jeanne Boyarsky

JUnit 5 (verified skill)
Skill verified by Jeanne Boyarsky

Chengwei Lee

Ranch Hand

Posts: 884

posted 17 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Originally posted by Jeanne Boyarsky:
A database replication tool could do this. Or you could write a script and kick it off with a cron job.

Would it be able to just replicate the delta?

SCJP 1.4 * SCWCD 1.4 * SCBCD 1.3 * SCJA 1.0 * TOGAF 8

If tomatoes are a fruit, then ketchup must be a jam. Taste this tiny ad:

Clean our rivers and oceans from home

https://www.kickstarter.com/projects/paulwheaton/willow-feeders