Re: Inserting 300.000.000 datasets ..

From: Nuno Souto <nsouto_at_nsw.bigpond.net.au.nospam>
Date: 2000/07/18
Message-ID: <39743252.2177372@news-server>#1/1

On Mon, 17 Jul 2000 18:46:22 GMT, "Hans-Jürgen Schönig" <a9601497_at_unet.univie.ac.at> wrote:

>
>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.
>

Sorry, I can't make it work either. I remember vaguely that in V6 it was possible to have the control statements and the data coming in from STDIN. But I've just poured over all the V8 and 8i doco and can't find how to do it now.

Does anybody else know how?

Without that, I'm afraid a named pipe won't work.

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