Re: SQL Loader from Memory

From: dushkin <dushkin_at_012.net.il>
Date: 14 May 2007 00:25:32 -0700
Message-ID: <1179127532.263251.159790_at_e65g2000hsc.googlegroups.com>


[Quoted] 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
Received on Mon May 14 2007 - 09:25:32 CEST

Original text of this message