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.
Ive never used named pipes in Unix? Does it depend
on the shell(I only know korn).
Anyone do this? 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?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Ryan
INET: ryan.gaffuri_at_cox.net
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).
Received on Thu Jan 15 2004 - 15:14:27 CST