Home » RDBMS Server » Server Utilities » Importing Data from Flat file to Oracle Database Tables
Importing Data from Flat file to Oracle Database Tables [message #342402] Fri, 22 August 2008 04:52 Go to next message
rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
We want to import data from flat files (, or | separated) to oracle database tables. Please let us know which is the most efficient and fast way to achieve the same.


PS: Mods please move this thread to correct section if it is in wrong one.
Re: Importing Data from Flat file to Oracle Database Tables [message #342413 is a reply to message #342402] Fri, 22 August 2008 04:59 Go to previous messageGo to next message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
SQL*Loader and external table.

Regards
Michel
Re: Importing Data from Flat file to Oracle Database Tables [message #342421 is a reply to message #342402] Fri, 22 August 2008 05:14 Go to previous messageGo to next message
rak007
Messages: 107
Registered: October 2006
Location: Mumbai / Pune, India
Senior Member
will these two be used together and would they be an efficient combo to realize the most efficient way to import large amount of data.
Re: Importing Data from Flat file to Oracle Database Tables [message #342433 is a reply to message #342421] Fri, 22 August 2008 05:58 Go to previous message
Michel Cadot
Messages: 64106
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Either one or the other, they use the same engine.
They are the most efficient ways to load a flat file in Oracle.

Regards
Michel
Previous Topic: Want to use Oracle sequence at the time of loadiing data
Next Topic: error : maximum length excedeed
Goto Forum:
  


Current Time: Mon Dec 05 02:57:17 CST 2016

Total time taken to generate the page: 0.05601 seconds