Home » SQL & PL/SQL » SQL & PL/SQL » Need inputs for inserting data in DB from .dat file.
Need inputs for inserting data in DB from .dat file. [message #228466] Tue, 03 April 2007 02:47 Go to next message
be2sp1
Messages: 52
Registered: September 2005
Location: India
Member
Hi,

In my project i have a scenario where in i need to insert the data present in the flat file to DB. The problem is the amount of data in the flat file is huge and it takes close to 5 hrs for putting all this data in DB after preparing insert statements for each row in flat file and subsequently uploading the same in DB (shell script reads the flat file and prepares the insert statements). Could you please suggest an alternative way to upload data in DB.

Thanks
Re: Need inputs for inserting data in DB from .dat file. [message #228471 is a reply to message #228466] Tue, 03 April 2007 02:58 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
sqlloader
Re: Need inputs for inserting data in DB from .dat file. [message #228552 is a reply to message #228471] Tue, 03 April 2007 06:13 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Or it's In-Database equivalent - External Tables
Previous Topic: Behaviour of Timestamp DataType
Next Topic: SP2-0310
Goto Forum:
  


Current Time: Thu Dec 08 12:43:15 CST 2016

Total time taken to generate the page: 0.05461 seconds