Home » SQL & PL/SQL » SQL & PL/SQL » Dump large tables...
Dump large tables... [message #355350] Thu, 23 October 2008 15:45 Go to next message
shoaib123
Messages: 118
Registered: December 2007
Location: Chicago
Senior Member

Hi

What tool ( oracle or third party) do u recommend or use to dump big tables into flat files containing 15 million or more rows...

1. I use UTL_FILE  - this is easy to use, but terribly slow

2. I use SPOOL in SQL*PLUS - this is faster then UTL_FILE, but still super slow and Plus causing heaving network traffic..

Please guide me on this..
Re: Dump large tables... [message #355353 is a reply to message #355350] Thu, 23 October 2008 15:51 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Why don't you search before posting?
This is a FAQ.
See http://asktom.oracle.com/~tkyte/flat/index.html

Regards
Michel
Re: Dump large tables... [message #355355 is a reply to message #355353] Thu, 23 October 2008 15:59 Go to previous messageGo to next message
shoaib123
Messages: 118
Registered: December 2007
Location: Chicago
Senior Member

MIke
With all your respect..I had chance to see on those scripts.. Tom mentioned the easy way to dump in that link not the fastest way..
Re: Dump large tables... [message #355412 is a reply to message #355355] Thu, 23 October 2008 23:47 Go to previous messageGo to next message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Did you really read the link?
Quote:
Here is a pro*c program that does it to a flat file very fast

Regards
Michel

Re: Dump large tables... [message #355413 is a reply to message #355350] Thu, 23 October 2008 23:50 Go to previous message
Frank
Messages: 7880
Registered: March 2000
Senior Member
SQLPlus should be run from the server. No network traffic.
Why would you run it from a client, if you expect millions of rows?
Previous Topic: delete date
Next Topic: Execute Immediate for Creating Table
Goto Forum:
  


Current Time: Fri Dec 09 17:27:40 CST 2016

Total time taken to generate the page: 0.28247 seconds