Hello,
Is there a way to load a memory bulk using SQL Loader instead of
loading the bulk from a file?
Thanks!

"dushkin" <dushkin (AT) 012 (DOT) net.il> a écrit dans le message de news: 1179065483.454896.82930 (AT) k79g200...oglegroups.com...
What do you want to do?
Post your issue instead of asking for implementing a solution
you imagine wihtout knowing if there is a technical solution.

And post your Oracle version (4 decimals).

Regards
Michel Cadot

Hello Michel,

I am investigating the SQL solution for loading a bulk of records to
an Oracle DB (ver 10 - currently I don't know exctly the precise
version). As I understood the SQL Loader uses a file of records to
load them to the database. I would like to avoid the operation of
writing the file to the disk and I'd like to create a memory bulk to
pass it as an input to the Loader. I need a nearly real time
operation.

Maybe also using direct JDBC commands is faster?

Hope it is clearer now.

Regards, Tal.




Michel Cadot כתב:

dushkin schrieb:
You don't have to write to file, because sqlldr input can be redirected.

Best regards

Maxim