Re: data transfer using dial-up

\ wrote:
> i have a distributed system. From where i have to bring all data to one
> database. All most all database is in oracle 10g and winxp. Now, the only way
> to transfer data is using dial-up. So, what should i do to transfer the data
> in reliable ways.
>
> Should i configure any gateway server or what else. Any help in this would be
> highly appreciable...
> any links would also be helpful..

Not really an Oracle question.. unless you want to discuss methods of propogating data from one Oracle database to another.

The dial-up transport mechanism is an o/s issue. The physical protocol is usually PPP (Point to Point Protocol) these days - used to be SLIP and others in the past.

TCP/IP runs over PPP. TCP is inherantly a reliable and robust Internet Protocol. Oracle uses TCP for network connectivity. Oracle itself supports features like two phased commits for dealing with reliability and consistency of distributed data transactions.

So there's nothing really on the Oracle side that makes a dialup connection different. Oracle does not know the difference between a 56KB PPP connection and a 10Gbit Infiniband SDP connection. Nor does it care as it is a o/s, network interface driver and protocol stack issue.

Of course, the issue on the app developer side is dealing with a very small pipe for data exchange with other databases. So it makes sense to reduce the amount of data that is to be exchanged. And ensure that special attention is paid to exception handling as the likelihood of Oracle exceptions (caused by dialup failures and errors) are increased.

--
Billy