Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

I have the task to pull a huge table from an Oracle DB into a SQL DB or SQL dump via the internet. The source DB (Oracle) is in an enterprise setting which I access via Cisco VPN (Split tunneling is not allowed).

I have tried a tool from Intelligent Converters: Progress is very slow, which seems to be a latency issue (84MB in 8 hours pulled), at this rate I need more than 60 days.

The table itself is extremely simple (no no views, storage produceres, no indexes, identities etc.). Options are restricted by the VPN that does not allow split tunneling: The moment the connection stands no internet connection is present on the connected machine, I therefore need physical access.

share|improve this question
2  
why not create a database dump using expdp, compress it and then transfer via scp? –  Sathya Aug 2 '11 at 9:45

2 Answers 2

up vote 0 down vote accepted

Why not create a database dump using expdp, compress it using bzip2 / gzip and then transfer via scp?

I'm assuming Oracle is hosted on a *nix based OS

share|improve this answer
    
expdp can only be imported by another Oracle database, so you'd need to do remote oracle export, compress, scp, local oracle import, copy from local oracle to local SQL (I guess SQL Server) –  Gary Aug 2 '11 at 23:47

Try to experiment on Oracle TCP related parameters Nagle algorithm (TCP_NODELAY).

You can also adjust sending/receiving data buffer (SDU/TDU/RECV_BUF_SIZE/SEND_BUF_SIZE) in tnsnames.ora or on OS level.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.