Re: Inserting 300.000.000 datasets ..

On Sat, 15 Jul 2000 11:06:49 GMT, "Hans-Jürgen Schönig" <a9601497_at_unet.univie.ac.at> wrote:

>
>I thought that named pipes should work and I have already some experience
>with named pipes but I had absolutely no chance - i'd simpl didn't work.
>Have you ever tried named pipes with SQL-Loader?
>Is there any possibility to use ordinary pipes?
>

No, not with SQL*Loader. Tried them with SQL*Plus and had to write the program I talked about. As soon as Plus sees a EOF that's it, it stops.

I think your problem would be that? Can you read one dataset and then it stops? Or it simply won't read off the named pipe at all?

Another thing to try: from memory, there is an option to have Loader read off the standard input instead of a file. That could be used to make the named pipe work as stdin can always be re-directed from a named pipe.

I don't think you'd have much luck with ordinary pipes. Of course if you can make Loader read off stdin, then it's possible.

Cheers
Nuno Souto
nsouto_at_nsw.bigpond.net.au.nospam
http://www.users.bigpond.net.au/the_Den/index.html Received on Sat Jul 15 2000 - 00:00:00 CDT