1

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.

Improve this question
1
  • 2
    why not create a database dump using expdp, compress it and then transfer via scp?
    – Sathyajith Bhat ♦
    Commented Aug 2, 2011 at 9:45

2 Answers 2

Reset to default
0

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

Improve this answer
1
  • 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
    Commented Aug 2, 2011 at 23:47
0

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.

Improve this answer

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .