| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.server -> 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.
--
 |
 |