Re: What is the best way to replicate few tables between 2 Oracle 10g severs ?

From: Bob Jones <email_at_me.not>
Date: Sat, 18 Apr 2009 10:53:27 -0500
Message-ID: <NHmGl.29333$>

"Veeru71" <> wrote in message
> We need to replicate (1-way) a bunch of tables from Server-A to
> Server-B in close to real-time.
> Server-B is located in a foreign country.
> Apporx. # of tables to be replicated : 50 (size : 50 GB)
> Approx amount of data that gets replicated (changed data) per day :
> 100 MB
> Oarcle Versions : 10g, Solaris
> Constraints (due to some security reasons):
> - Server-B SHOULD NOT have any DB-Links to connect to Server-A
> - No UserId/Password of Server-A should be used anywhere in scripts/
> code/config files, etc on Server-B.
> What is the best way to achieve this ? Initially we thought of using
> Matreialized Views, but because of the above constraint, it may not
> be feasible.
> Do you think Oracle Streams would work ? Would it be an over-kill ?
> Any other options ?
> Thanks for your help.

Basic replication is the easiest solution. Just have everything set up on Server A to meet your security requirements.

Streams will work too if you have EE but would not be my first choice. Received on Sat Apr 18 2009 - 10:53:27 CDT

Original text of this message