Hi there,

is there any data replication tool for oracle 8 or higher which is able to
sync. serveral selected records from serveral tables from one database to
another?

It must be able to handle FK-chains, automatically generated id's (via
triggers and sequences) and sequence-depending keys.

It would be nice if it would provide a GUI to select the data, no must.

It must have a free eval at least.

On Wed, 9 Jul 2003 19:11:05 +0200, "Christoph Seidel"
<christoph.seidel1 (AT) gmx (DOT) de> wrote:


Yes it is called advanced replication and it comes with Oracle. Any
reason why you can't use it?


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

Christoph Seidel wrote:
Cost: depends on the oracle rep you talk to... It comes with the
Enterprise Edition...
Info: All Oracle information is available electronically on
tahiti.oracle.com

--
Regards, Frank van Bortel

"Christoph Seidel" <christoph.seidel1 (AT) gmx (DOT) de> wrote

Good news! It comes in the box, and it's easy and reliable!
Look up replication/snapshots/materialized views in the Oracle documentation
you already have.

Regards,
Paul

Frank wrote:

Well after reading a bit and playing a bit with it: it seems that it can
only copy complete tables. What I need is:

The user selects record 1, 30 and 100 from a table and only these records
and the data they depend on are copied.

On Thu, 10 Jul 2003 19:58:52 +0200, "Christoph Seidel"
<christoph.seidel1 (AT) gmx (DOT) de> wrote:


Not true.
Read again


Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address

Sybrand Bakker wrote:

Yes, that's it, random. So it seems that OAR is not my friend?!