migrating oracle tables through vpn

[ajji]

Hello,

I am trying to migrate an oracle database (not too big, 150 Mb of data) through vpn but even if the querries work fast locally doing them through VPN is very slow. Is this coming from the vpn connection, is it way to optimize this?
What is long is the time a query need to be sent to oracle or the time the oracle connection is opened for eeach query...
As the migration of this oracle database requires lots of querries the complete operation take a very long time.

Thank you for your help.

 

[sem]

You may access that database via the thinnest remote client you have (prefferably telnet), export and compress there and then get this compressed image.

Regards, Dima

http://seminihin.narod.ru

 

[ajji]

thank you for your reply

telnet would not be secured enough, but your advice is then not to accces the oracle database directly but do a dump and load it to a local oracle database and then migrate the data to mysql. Is this what you recommended ?
I was thinking that doing the query remotely would have been easier as we don't have to do a dump and a load before... But I did not think that it will be so slow...

 

[sem]

Telnet is not less secure than your VPN
Besides without special settings (doubt they were made in your case) sql*net is completely transparent, may be a bit less clear for human processing.


Regards, Dima

http://seminihin.narod.ru