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.

Report message to a moderator

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: 68352
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://tkyte.blogspot.fr/2009/10/httpasktomoraclecomtkyteflat.html

Regards
Michel

Report message to a moderator

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?

Report message to a moderator

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: 68352
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Wed Feb 08 02:05:39 CST 2023
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.