Re: Oracle Database Question

From: Daniel A. Morgan <dmorgan_at_exesolutions.com>
Date: Sun, 25 Feb 2001 20:32:08 -0800
Message-ID: <3A99DC47.F1CC3FEB@exesolutions.com>

> I'm very new to Oracle and I have a customer who has an interesting
> question. I don't know if what he wants can be done.
>
> We run Oracle 7.4 on a Solaris platform. My customer wants to know if we
> can have our Enterprise 3500 server be a central location of a database and
> have other servers (that are overseas) connect into our server and populate
> the database.
>
> Others in my office have speculated that since we are using a TCP/IP
> connection, we probably won't be able to keep a steady connection, with all
> the time outs that might occur.
>
> Is this do-able and if so, where can I learn more about it? I appreciate
> the help!!

In theory it is certainly possible. Though I would definitely upgrade to 8i. Look at Oracle's advanced replication package and also at the possibility of writing a DBMS_JOB package to do it. Really depends on how close to real-time you need to be.

Daniel A. Morgan Received on Sun Feb 25 2001 - 22:32:08 CST