Re: sql*loader and stdin?
From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Mon, 09 Jan 2006 21:29:38 +0100
Message-ID: <dpuh3j$4on$2_at_nntp.fujitsu-siemens.com>
>
>
> You have to properly quote the stdin:
> On unix works both
> cat load.dat|sqlldr control=load.ctl userid=user/password data=\"-\"
> cat load.dat|sqlldr control=load.ctl userid=user/password data=\'-\'
>
> On windows
> type load.dat|sqlldr control=load.ctl userid=user/password data=\"-\"
>
> Alternative (for both , unix and windows)- infile syntax:
> --------------
> load data
> infile "-"
> into table...
> --------------
>
> Metalink note 191043.1 may be interesting for you as well.
Wow, that did it!
Date: Mon, 09 Jan 2006 21:29:38 +0100
Message-ID: <dpuh3j$4on$2_at_nntp.fujitsu-siemens.com>
Maxim Demenko wrote:
> Volker Hetzer schrieb:
>
>> Hi! >> Is there any way I can make sql*loader read data from stdin? >> >> Lots of Greetings! >> Volker
>
>
> You have to properly quote the stdin:
> On unix works both
> cat load.dat|sqlldr control=load.ctl userid=user/password data=\"-\"
> cat load.dat|sqlldr control=load.ctl userid=user/password data=\'-\'
>
> On windows
> type load.dat|sqlldr control=load.ctl userid=user/password data=\"-\"
>
> Alternative (for both , unix and windows)- infile syntax:
> --------------
> load data
> infile "-"
> into table...
> --------------
>
> Metalink note 191043.1 may be interesting for you as well.
Wow, that did it!
Thanks a whole lot (and also thanks to all who replied)! Volker Received on Mon Jan 09 2006 - 21:29:38 CET