| Need you guys help!! [message #58240] |
Fri, 08 August 2003 18:49  |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
Hi guys,
I have table with 100 columns with one blob field.. am using sqlldr to load data from flat to oracle table.. and its taking 3 hrs to load 260k rows.. is there any way i can speed up the load? please need you guys help!!
|
|
|
|
| Re: Need you guys help!! [message #58241 is a reply to message #58240] |
Fri, 08 August 2003 22:35  |
sai sreenivas jeedigunta
Messages: 370
Registered: November 2001
|
Senior Member |
|
|
hi,
looking at u r task...speed cannot be reduced drastically...however I have an idea ...why dont u choose an application like VB to do this job ? I think data operations through odbc is little faster...
Also, see what others hav to say on this..
sai
|
|
|
|
|
|
| Re: Need you guys help!!... Here is some Info [message #58248 is a reply to message #58247] |
Sat, 09 August 2003 12:23 |
sidd
Messages: 130
Registered: May 2003
|
Senior Member |
|
|
|
my avg row length is 1000 + blob and blob would have an avg of (20,000) all in characters.. so on the whole a row can have upto 20,000+1000 characters.. and my data file is 300MB , am using conventional path... there is no way i can use direct path load bcoz am using freaking number of functions to format the data.. i would be glad to try any other method. right now its taking 2 and half hrs to load data. i want improve the performance.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
