Home » RDBMS Server » Server Utilities » What could be the fastest way to unload the data from oracle to text file. (oracle 11i)
What could be the fastest way to unload the data from oracle to text file. [message #557580] Thu, 14 June 2012 01:55 Go to next message
guruoracle123
Messages: 5
Registered: September 2010
Junior Member
We have around 30 million rows in a table which we are extracting through UTIL_FILE and sending this file to somewhere to other systems.

But this extraction taking too much time.

Is there any way out to optimize this process or any new stuff.
Re: What could be the fastest way to unload the data from oracle to text file. [message #557585 is a reply to message #557580] Thu, 14 June 2012 02:20 Go to previous messageGo to next message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://tkyte.blogspot.fr/2009/10/httpasktomoraclecomtkyteflat.html

Regards
Michel
Re: What could be the fastest way to unload the data from oracle to text file. [message #558198 is a reply to message #557585] Wed, 20 June 2012 03:48 Go to previous messageGo to next message
muralikri
Messages: 638
Registered: August 2011
Location: chennai
Senior Member

@Micheal,what you posted links.it will describes as text file to table load. it this correct one?
Re: What could be the fastest way to unload the data from oracle to text file. [message #558206 is a reply to message #558198] Wed, 20 June 2012 04:27 Go to previous message
Michel Cadot
Messages: 67369
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
It describes how to unload a table to a flat file which is what is asked.

Regards
Michel
Previous Topic: oracle environment setting
Next Topic: unable to do partial export in linux
Goto Forum:
  


Current Time: Thu Sep 24 04:17:18 CDT 2020