hi all
i want to insert 110 million record in oracle database but i am using java application to insert the data but it takes 4 days to complete i check the program to see if there is a problem but what i found that the insert to the database what takes a long time i will be greatful for any help
lena1990
-3
Junior Poster in Training
Recommended Answers
Jump to PostDepending on what format the source data is in you might want to look at BULK INSERT. You could also look at
Jump to PostI'm more familiar with MS SQL but a safe format is usually one record per line with all fields enclosed in double quotes and separated by commas.
All 6 Replies
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
lena1990
-3
Junior Poster in Training
Reverend Jim
4,780
Hi, I'm Jim, one of DaniWeb's moderators.
Moderator
Featured Poster
debasisdas
580
Posting Genius
Featured Poster
lena1990
-3
Junior Poster in Training
lena1990
-3
Junior Poster in Training
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.