Re: Replication

I've worked on a very successful project using oracle replication.

It was a production recording system and customer sales. The master site was the sales site, and each production site had a small server, with only the data needed to run production (using horizontal and vertical partitioning).

We predominately used updatable snapshots, refreshing (and pushing transactions) at rates between daily and every 5 mins.

Two things that should be planned from the beginning :

Ensure that the data model is approriate for replication. Ensure that the application will not cause any conflictions.

This was implemented in 7.1.6, 7.2.3 and 7.3.3 for different customers.

Oracle 8 replication of updatable snapshots is much more effiecent.

Andy Tasker
Spirocom Analysts Ltd.

JRStern wrote in message <352bbdd2.4409654_at_news1.occa.home.net>...
>Does anybody use, trust, and like Oracle replication? We are starting
>development on a new app, and are considering some designs that might
>benefit from replication. New to Oracle, I have been told that it's
>likely better to do a join across databases (horizontally partitioned
>datasets, in effect), that certainly this is cheaper because Oracle
>replication costs big money.
>
>Any comments on the above.
>
>Thanks in advance.
>
>Josh
>
Received on Fri Apr 10 1998 - 05:15:20 CDT