Replication questions Oracle 8.0.5

From: AJ <auj_at_storebrand.no>
Date: Tue, 15 Sep 1998 21:51:36 +0200
Message-ID: <6tmggk$qdp$1@readme.uio.no>

In my first project as DBA, we are going to replicate data between Oracle Server and Personal Oracle ver. 8.0.5. We will use SP and the replication API to do the replication. I have a few questions in this matter.

The users will be able to insert new records in their local db (laptop) and replicate these back to the central db. The records will need unique keys (PK). Is there an easy way to generate this locally, or should they be generated by a SP when they are replicated back?

The central and local db are identical. Is it possible to replicate object changes to the local db (which contains no data) if the central db changes?

Are there other things I should be aware of when it comes to replication?

TIA Received on Tue Sep 15 1998 - 14:51:36 CDT