Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Data replication in real time

406590Jun 24 2004 — edited Sep 16 2005
For security reasons, we have two Oracle 9.i database servers (Windows Server 2003 as O/S):

We have a database server A in our internal network, which is our Intranet, too.

We have a database server B, out of our Intranet but in our internal network, which can be accessed through Internet and any Internet user with a certain password can insert, update or delete records.

Both database servers A and B have the same structure, but their data is different. Database A can be accessed from our Intranet and its records can only be updated for our Intranet users. Database B is only available for Internet users (out of our Intranet) and they also can update its records.

**We need that both databases have the same data at any time.**

Is it possible to REPLICATE in real time both database servers? Is there any set up or configuration that we must follow to achieve that?

Thanks in advance!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 14 2005
Added on Jun 24 2004
5 comments
1,059 views