Re: Problem Needs Help

In your case you need a replicated environment called "Advanced Replication Option" from oracle.

Perhaps you can install a master/snapshot replication, when you need only a part of the contents of
your tables.

allasrosa_at_my-deja.com wrote:

> Hi,
>
> I have a remote Oracle 7.3 database located in another district
> within the city. THe connection between the server and the local
> office relies on a telephone line and a modem. The application
> (developed with Oracle Power Object) running on the local PC needs to
> retrieve and update the database quite frequently every day. The
> network traffic can be heavy in peak hour. So, u can imagine how
> slow the app respond time will be.
>
> I just cannot change the connection method and have to stick
> to it for at least a year or more. Now i'm thinking of some methods
> to improve this situation.
>
> Can i make a local copy of the remote database to the local pc so that
> my app can use? But *how* to do it? And, another problem comes, how
> can i sync the data in the pc with the remote database? (THe phone
> line is free from trafic after office hour. I may make use of it).
>
> Or there are other ways to solve the problem?
>
> Much much thanx indeed.
>
> Rgds,
> Allas
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.

--
-------------------------------------
ADICOM Informatik GmbH
Andreas Michler
Wiesfleckenstr. 34
72336 Balingen
Tel: 07433/9977-57,Fax: -90
E-Mail: Andreas.Michler_at_adicom.de
http:\\www.adicom.de
-------------------------------------