Re: Using Replication...?

BTW - enterprise edition is very much more expensive than standard and since you have a well defined master database, my choice would be 1.

Ted

On Sun, 24 Dec 2000 14:02:06 +0100, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:

>This can be resolved in either of two ways
>1 in any edition of Oracle 8i:
>create database links from the master database to all individual local
>databases. Then write pl/sql procedures taking care of the synchronization
>and run them as pl/sql batch jobs. Refer to the documentation on dbms_job
>for submitting jobs and the sql reference manual (all manuals are online at
>http://technet.oracle.com)
>2 in the Enterprise Edition only:
>setup advanced replication (this is a separate option which is not available
>in Oracle standard edition). Typically this would involve setting up
>so-called snapshots.
>The documentation kit has 2 seperate manuals on distributed databases.
>As your question is a rather broad one, and you didn't provide too much
>detail, I think I should leave it at this.
>
>I assume handling this through Access must have been a continuous nightmare.
>
>Regards,
>
>Sybrand Bakker, Oracle DBA
>
>"Chris Lee" <clee_at_innocent.com> wrote in message
>news:3A45C285.4ABABC9C_at_innocent.com...
>> Hi,
>>
>> I need your advice for the following situation: In my company, we have a
>> master database in the main office, and we have some local databases in
>> the branches. Each local database will handle its local transactions.
>> Every night, the local transactions in the local databases will upload
>> the transaction data to the master database in the main office. And the
>> master database will send some master data to the local databases. (The
>> master data has no conflict to the transaction data.) Right now, we are
>> doing this using MS Access. But we would like to switch to Oracle 8i
>> since we have encountered a lot of problems with MS Access. But the
>> problem is we don't know enough about Oracle 8i in this area. I am sure
>> we can handle the above situation using Oracle 8i; we just don't know
>> how to set up the Oracle databases to handle the above situation at this
>> point. Could anyone please give me any suggestions? Is there any
>> documentation or article that can help me?
>>
>> Thanks for your advice in advance.
>>
>> -- Chris
>
>

EMail: knijff_at_bigfoot.com Received on Wed Dec 27 2000 - 15:23:07 CST