| SQL Loader [message #74758] |
Sun, 13 February 2005 15:10  |
M. Forouzangohar
Messages: 2
Registered: February 2005
|
Junior Member |
|
|
Hi,
I use sql loader to import data from 80 CSV flat files(with diffrent formats).For each CSV it took about 20 seconds with this command:sqlldr Control= UserId= Direct=true , and most of the time spent for 80 connection times, not for importing proccess itself.I need to know if there is any way to import all 80 flat files by sql loader in only one session instead of 80 sessions to save the time.
Thanks in advance,
M. Forouzangohar
|
|
|
|
| Re: SQL Loader [message #74769 is a reply to message #74758] |
Mon, 14 February 2005 05:18  |
Frank Naude
Messages: 4587
Registered: April 1998
|
Senior Member |
|
|
Hi,
If you can programmatically differentiate between the records, you can use the "INTO TABLE ... WHEN ..." syntax. For details read the Database Utilities User Guide.
Best regards.
Frank
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
