Member Avatar for lena1990

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

  • 3 Contributors
  • 6 Replies
  • 149 Views
  • 2 Days Discussion Span
  • Latest Post Latest Post by lena1990
Member Avatar for Reverend Jim

Depending on what format the source data is in you might want to look at BULK INSERT. You could also look at bulk load

Edited by Reverend Jim
Member Avatar for lena1990

could you explain more the data source is text file but i have do some modification on that text file before it is inserted to the database

Member Avatar for Reverend Jim

I'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.

Member Avatar for debasisdas

Try using /*+ APPEND */ hint

The APPEND hint instructs the optimizer to use direct-path INSERT.In direct-path INSERT, data is appended to the end of the table, rather than using existing space currently allocated to the table. As a result, direct-path INSERT can be considerably faster than conventional INSERT.

Member Avatar for lena1990

could you explain how to do it you should know that i am using java application to insert the data

Member Avatar for lena1990

i use the append hint but it does not reduce much time that i need i need a way to insert the 110 milion in 12 hours or less if you can???

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.