Re: What is the best way to replicate few tables between 2 Oracle 10g severs ?
Date: Sat, 18 Apr 2009 10:53:27 -0500
"Veeru71" <m_adavi_at_hotmail.com> 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