Re: utility to synchronize tables over a database link

"Matthijs Rademakers" <Matthijs.Rademakers_at_nos.nl> wrote in message news:9d94gs$6cu$1_at_porthos.nl.uu.net...
> Thanks for the advice, though it was not really what I had in mind. Your
> solution assumes that two applications have a permanent databaselink and
> that these applications are somehow functionally related (OLTP).
>
> I am looking for a utility that allows me to transport table data from
> development to acceptance to production etc as an alternative to using
> SQL-scripts.
> The oracle package that I have in mind to do this, contains a procedure,
> call it SYNCHRO, with parameters like:
> - table_name IN VARCHAR2
> - to_dbsid IN VARCHAR2
>
> The procedure SYNCHRO then looks for the existence of a database link to
 the
> specified database (to_dbsid) and the existence of a completely identical
> table on the database specified by to_dbsid. Let's call this table
> 'table_name_at_to_dbsid'. If the tables prove to be identical in number of
> columns, datatypes etc, then SYNCHRO would
> make sure that the table data in 'table_name_at_to_dbsid' got upstaged to the
> contents of table_name.
>
> Surely someone else has done this before!
>
> Regards,
>
> Matthijs Rademakers,
> Oracle Dev
>
>

What about using the advanced replication facility present in the Enterprise Edition of Oracle.
This does exactly what you describe above!

Regards,

Sybrand Bakker, Oracle DBA Received on Tue May 08 2001 - 18:50:48 CEST