Home » RDBMS Server » Server Utilities » exporting huge amount of data (Oracle Database 10g Enterprise Edition Release - 64bit, unix)
exporting huge amount of data [message #517302] Mon, 25 July 2011 05:25 Go to next message
Messages: 46
Registered: May 2011
Location: Venice, Italy
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


  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: 68501
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
T. Kyte's How Can I unload data to a flat file


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

Current Time: Sun Sep 24 05:09:49 CDT 2023