Re: sqlldr from pipe

Nick Taylor wrote:

> Hi
>
> We're using Oracle 8.1.6 under SuSE Linux. Is there any way to pipe data
> into the standard input of sqlldr?
>
> I would like to be able to bulk load tables on a regular basis from
> output from a legacy system dump program, but without dumping all data
> into files first.
>
> Additionally this would allow input from gzip files via: [Quoted]
> "zcat file | sqlldr..."
>
> I am unaware of any alternative loading mechanism that is anywhere near
> as fast as sqlldr using direct load. My java version does my job, but
> relatively slowly, I guess because of the logging. This simply then
> harks back to the numerous requests for loading without logging :-(
>
> TIA
>
> Nick
> --
> Nick Taylor
> Say No to Spammers - What You See Isn't What You Get to Email Me

I don't believe you can do this with SQL Loader without driving the executable with a Perl or shell script run by a Chron job.

Within Oracle you can use DBMS_JOB and UTL_FILE.

Daniel A. Morgan Received on Sat Jul 21 2001 - 23:52:07 CEST