Home » RDBMS Server » Server Utilities » exporting huge amount of data (Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit, unix)
exporting huge amount of data [message #517302] Mon, 25 July 2011 05:25 Go to next message
orsoghu
Messages: 43
Registered: May 2011
Location: Venice, Italy
Member
Hi guys,

somebody asked me for some kind of mysterious reason to extract a huge amount of data from a couple of views... the problem is that they want it in TXT files with fixed record length.
There will be like 6 files, for a total amount of about 10GB.

How would you suggest to export those tables in the fastest possible way?
If I'm not mistaken exp and expdp can't create txt files, so do I really need to use utl_file or spool?

In case you need it I attached an explain plan of what I need to do

PS:

  1. i can't use parallel hints
  2. i can't modify the query you'll see in the explain plan
Re: exporting huge amount of data [message #517305 is a reply to message #517302] Mon, 25 July 2011 05:34 Go to previous message
Michel Cadot
Messages: 58938
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
T. Kyte's How Can I unload data to a flat file

Regards
Michel


Previous Topic: sql loader help
Next Topic: EXP-00107 Error
Goto Forum:
  


Current Time: Fri Aug 29 15:33:13 CDT 2014

Total time taken to generate the page: 0.22100 seconds