Re: sql*loader and stdin?
From: Maxim Demenko <mdemenko_at_arcor.de>
Date: Mon, 09 Jan 2006 09:55:57 +0100
Message-ID: <43c225aa$0$20775$9b4e6d93_at_newsread4.arcor-online.net>
load data
infile "-"
into table...
Date: Mon, 09 Jan 2006 09:55:57 +0100
Message-ID: <43c225aa$0$20775$9b4e6d93_at_newsread4.arcor-online.net>
[Quoted] 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
[Quoted] 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.
Best regards
Maxim Received on Mon Jan 09 2006 - 09:55:57 CET