Re: SQL Loader from Memory

dushkin schrieb:
> 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" <dushkin_at_012.net.il> a écrit dans le message de news: 1179065483.454896.82930_at_k79g2000hse.googlegroups.com...
>> | Hello,
>> | Is there a way to load a memory bulk using SQL Loader instead of
>> | loading the bulk from a file?
>> | Thanks!
>> |
>>
>> 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

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

Best regards

Maxim Received on Mon May 14 2007 - 10:02:07 CEST