| exporting huge amount of data [message #517302] |
Mon, 25 July 2011 05:25  |
orsoghu
Messages: 46
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:
- i can't use parallel hints
- i can't modify the query you'll see in the explain plan
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
