Page 1 of 1
toraloader how to do parallel loading
Posted: Mon 18 Jul 2005 14:38
by oxford
hi
is there a way to parallel load data into the database when using the toraloader (sql*loader mode )
thanx
Posted: Thu 21 Jul 2005 12:09
by 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
Multithreaded TOraLoader
Posted: Thu 10 Mar 2011 11:16
by 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
Posted: Mon 14 Mar 2011 09:24
by 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.
Posted: Wed 16 Mar 2011 17:20
by LarthaL
Thank you for your kind reply Alex.
I will keep lmDirect mode in a single thread.
Posted: Thu 17 Mar 2011 08:17
by AlexP
Hello,
If any other questions come up, please contact us.