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.

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
SQL*Loader and external table.

Regards
Michel

Report message to a moderator

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.

Report message to a moderator

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: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Dec 24 11:08:04 CST 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.