Re: named pipes, sql loader and ftps

Comments inline
On 01/15/2004 04:14:27 PM, Ryan wrote:
> I was flipping through Tim Gorman's Data Warehouse and he has a short section on using named pipes to kick off > sql loader when you send files to your data warehouse with ftps.

Tim is a resourceful guy. I scripted it once for export.

>
> Ive never used named pipes in Unix? Does it depend on the shell(I only know korn).

No, it doesn't depend on the shell. You create named pipe by using mknod <pipe name> p. Some Unix versions have specialized command called "mkpipe".

>
> Anyone do this?

Yup.

> With this method you can start doing your sqlloader while still recieving your file. Anyone >
> ever do this with automated file reciept?
> Files come in over night and the sqlloader gets kicked off?

Since the advent of the external tables, loader is no longer a must.

>

--
Mladen Gogala
Oracle DBA
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mladen Gogala
  INET: mladen_at_wangtrading.com

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).