Re: Inserting 300.000.000 datasets ..

From: Hans-Jürgen Schönig <a9601497_at_unet.univie.ac.at>
Date: 2000/07/17
Message-ID: <2wIc5.61654$7D2.947526@news.chello.at>#1/1

Im Artikel <39705d7e.1623962_at_news-server> schrieb nsouto_at_nsw.bigpond.net.au.nospam (Nuno Souto):
> 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

How does it work using STDIN with SQL*Loader? can I simply write: xy | sqlldr db/db - ??? I've tried something like this but it didn't work. Received on Mon Jul 17 2000 - 00:00:00 CDT