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
[EMAIL PROTECTED]
-Original Message-
From: Csillag Zsolt [SMTP:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).