0

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
22
Views
4 Years
Discussion Span
Last Post by lena1990
0

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

0

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.

0

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.

0

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

0

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???

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.