Re: Sqlldr and standard input

Have you tried it?

It should work similar to what is done for imp/exp to a pipe.

You are on a *nix system aren't you?

assuming a gzipped file:

mkfifo sqlldr.pipe
gunzip --stdout myfile.gz > sqlldr.pipe & sqlldr parfile=yourparfile.par

the .ctl should use the pipe name for the infile.

eg.
load data
infile 'sqlldr.pipe'
into table t1
fields terminated by ',' optionally enclosed by '"'

(

   V1
)

Jared

On 2/5/07, Ken Naim <kennaim_at_gmail.com> wrote:
>
> I have googled and metalinked unsuccessfully for how to use standard
> input to provide data to sql loader. The purpose of this desire is to
> not have to uncompress, load and then recompress files for loading.
>
> Thanks,
> Ken
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist

--
http://www.freelists.org/webpage/oracle-l