Re: Oracle Replication Option

From: Bostjan Stupica <bostjan.stupica_at_ixtlan.si>
Date: 1997/04/24
Message-ID: <01bc50c8$439e9980$33ab4dc1@pc_bostjans>#1/1

Hello!

Rajs wrote in article <5jk40p$ems_at_lori.zippo.com>...
> Hi,
> This is a question posed to anybody who has actually used the
> replication option of Oracle 7.3 Workgroup Server/Enterprise.
> Our project has the following configuration
> Oracle 7.3 Wkgrp Server/WindowsNT and PB 4.0
> The client wants to replicate certain table information across
> his different branches.
> Replication is an option being considered.
> - Is the replication row/column level ?
Yes, you could provide that.
Exm.: SELECT * FROM DEMO.JOB WHERE JOBID > 700;

> - If synchronous replication is used are the overheads very high
I don't understand the question.
If you'll use synchonus replication (Multi-Master), you'll don't have to wory about any kind of conflitcs, but all the transactions will be slower, because the transaction will COMMIT on all sites or woun't COMMIT at all (then will ROLLBACK at all sites).

> - Since the database is already existing does it warrant any
> database design ?

No. But depends how will you start the replication environment!

> - Do the application programs have to altered in any way.
Hmmm ... well that depends on haw the database is designed and what kind of replication option will you chose.

>
> Information will be much appreciated.
> Rajs
>

Byebye,
Bostjan Received on Thu Apr 24 1997 - 00:00:00 CDT