Re: exchange data between 2 servers without oracle link

From: Peter Winters <peterw_at_trinitysoftware.com.au>
Date: Fri, 14 Jan 2000 08:30:54 +1000
Message-ID: <newscache$t7paof$eym$1@news.iig.com.au>

Try utilising the Oracle standby server concept. This is where you have a primary server in archivelog mode, you then transfer the archive logs to the standby server, on the stnadby server you apply these logs making the instances of this database the same as the primary server.

The transfer of archivelogs can be via the network, ftp and the restoration of these logs can be done via scripts.

Regards
Peter Winters
Cairns, Queensland, AUSTRALIA.

. <tassili_at_club-internet.fr> wrote in message news:85lgss$238$1_at_front1.grolier.fr...
> Hi
> Sorry for english,
> i have a problem :
> i want exchange data between 2 bases without sqlnet or others oracle link.
> i have a solution when i use utl_file package : on a table, in post-insert
> trigger i generate an insert order in file
> and with an unix job i transfert file to second server and execute the sql
> file.
> it's not secure
>
> Have you another solution ?
> thank you for your help
>
> Tassili_at_club-internet.fr
>
>
Received on Thu Jan 13 2000 - 16:30:54 CST