By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
440,213 Members | 2,172 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 440,213 IT Pros & Developers. It's quick & easy.

Performing Bulk Inserts

P: 37
Hi,

I have been searching but haven't had any luck finding a method of performing bulk inserts of data into Oracle comparable to using the BCP utility with MSSQL.

In our MSSQL environment I typically prepare some file data using a perl script to parse and format the data into a comma-delimited format, then use BCP to bulk insert the records into the SQL database tables either manually or on a schedule. It works very efficiently.

Is there some similar utility available in Oracle to perform this type of bulk data insertion? If anyone has any documentation or recommendations for how I can do this it would be appreciated.

I need to begin a parallel implementation of Oracle into our environment.

Thanks!
Apr 11 '07 #1
Share this Question
Share on Google+
2 Replies


P: 37
P.S. I thought I should add that I have found some information for SQL*Loader but no documentation that is quite thorough on how to use it via sample and etc. So if any suggestions would be to use this, could you kindly provide some URL's that have good examples?

And is this the only option available for what I am trying to do?

Thanks again.
Apr 11 '07 #2

debasisdas
Expert 5K+
P: 8,127
use sql * loader for the purpose

create two files
1.control file(.ctl)
write the following code into the file
<code>
load data
infile 'd:\debasis\data.dat'
append
into table mydept
fields terminated by " "
(deptno,dname,loc)
</code>
2.create a data file (.dat)
in that file store some data separated by " " (can use any other delimeter also can use CSV file)

then run sql loader
Apr 13 '07 #3

Post your reply

Sign in to post your reply or Sign up for a free account.