toraloader how to do parallel loading

[oxford]

hi
is there a way to parallel load data into the database when using the toraloader (sql*loader mode )

thanx

[Alex]

You can't use TOraLoader in multithread environment, so there is no parallel loading feature in ODAC using Oracle direct path feature. You can use DML array feature for such tasks. For example of using DML array see DMLArray ODAC demo project

[LarthaL]

Hi Alex, i can see using ODAC 6.50.0.39 with Delphi 2007 that is still true your affirmation saying TOraLoader can't be user in a multithreaded environment.

I.e. I can't write an application such as for every external file there is a thread with its own TOraSession and TOraLoader running concurrently.
Trying to do so every thread is, using Oracle Client 10g 10.2.0.4, executed serially.

Is there any chance that this feature will be implemented?

Thank you

My environment is:
ODAC 6.50.0.39
Delphi 2007
Windows XP SP3 (Italian)
Oracle Client 10g 10.2.0.4

The server is:
RedHat Linux 5.1 x64
Oracle Database 10g R2 10.2.0.4 x64

[AlexP]

Hello,

Unfortunately, we can't implement this feature in the lmDirect mode, this limitation is connected with the Oracle behavior.
You can use only the lmDML mode for such task.

[LarthaL]

Thank you for your kind reply Alex.
I will keep lmDirect mode in a single thread.

[AlexP]

Hello,

If any other questions come up, please contact us.