RE: Data transfer between 2 databases

I think that this situation called for master to master replication. In this situation updates to each DB are forward to the second DB.

What connection do you have between the two computers? In our installation there is NO connection between internet and intranet.

The dynamic TCP/IP address can be resolved using DNS and working with the computer NAME instead of TCP/IP address.

Yechiel Adar, Mehish Computer Services
adary_at_mehish.co.il

> -----Original Message-----
> From: Csillag Zsolt [SMTP:starsoft_at_interware.hu]
> Sent: Mon, March 25, 2002 10:48 AM
> To: Multiple recipients of list ORACLE-L
> Subject: Data transfer between 2 databases
>
>
> Hi,
>
> I have an Oracle Database on Intranet network that is used for internal
> program ( insert, update etc.).
>
> The other database will be at the Internet provider and our cgi will run
> on it.
> Because the users on the Internet should see the actual data and the users
>
> can make some inserts
> in the database - I need to transfer records in both way, from one
> database
> to the other and inverse.
>
> What makes my problem even worse - only the Internet provider's Oracle has
>
> fix IP address, the other
> that is on the internal network doesn' t.
>
>
> Thank you in advance
>
> Zsolt Csillag,
>
> Hungary
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Csillag Zsolt
> INET: starsoft_at_interware.hu
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?=
  INET: adary_at_mehish.co.il

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).