Sql -loader and parallel [message #74128] |
Thu, 16 September 2004 09:55 |
Nauj
Messages: 33 Registered: February 2004
|
Member |
|
|
Hello,
I'm trying to use sql-loader with parallel option.
I have loaded data with and without parellel but it takes same time. I don't appreciatte a better perfomance with parallel.
In the called to sqlldr i'm adding PARALLEL=TRUE. That is the only change i have made.
Do i have to make any 'alter table' with my Oracle table??.
Any advice will be greatly appreciatted.
Nauj
|
|
|
|
Re: Sql -loader and parallel [message #74131 is a reply to message #74129] |
Thu, 16 September 2004 23:15 |
Nauj
Messages: 33 Registered: February 2004
|
Member |
|
|
Thank for your help, Mahesh
I'm working in a IBM multiple CPU system and my table is partiotioned, i think i have a good situation to use parallel.
I'm using both parallel and direct load.
I'll will continue trying...
|
|
|