Re: Using Replication...?

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
Received on Sun Dec 24 2000 - 07:02:06 CST