Dump large tables... [message #355350] |
Thu, 23 October 2008 15:45  |
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 #355355 is a reply to message #355353] |
Thu, 23 October 2008 15:59   |
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..
|
|
|
|
|