Almost forgot. Wanna do this on Windoze? Forget it, it won't work. You can't make it work. There are some Oracle employees that no doubt could make it work, but the binaries shipped to the public are linked with MS std lib, and they do not support output to a pipe from the command line. It's quite a paradox. MS provides an extremely robust implementation of pipes, but does not make them available from the command line. Jared Jared.Still@xxxxxxxxxxx Sent by: oracle-l-bounce@xxxxxxxxxxxxx 05/12/2004 02:39 PM Please respond to oracle-l To: oracle-l@xxxxxxxxxxxxx cc: Subject: Re: &^@#%$@#%$ stinkin' oracle7 database here's the promised (rough) example script Run the import script first, as the listening side must be running prior to the sending side. Import script ------------------------------ !/bin/ksh rm /tmp/imp_pipe mkfifo /tmp/imp_pipe imp userid=jkstill/$(opass) file=/tmp/imp_pipe log=imp.log fromuser=jkstill touser=jkstill & netcat -l -p 16485 > /tmp/imp_pipe ------------------------------ Export script ------------------------------ #!/bin/ksh rm /tmp/exp_pipe mkfifo /tmp/exp_pipe exp userid=jkstill/$(opass) tables=jkstill.pipetest file=/tmp/exp_pipe & cat /tmp/exp_pipe | netcat rsysdevdb 16485 ------------------------------ ---------------------------------------------------------------- Please see the official ORACLE-L FAQ: http://www.orafaq.com ---------------------------------------------------------------- To unsubscribe send email to: oracle-l-request@xxxxxxxxxxxxx put 'unsubscribe' in the subject line. -- Archives are at //www.freelists.org/archives/oracle-l/ FAQ is at //www.freelists.org/help/fom-serve/cache/1.html -----------------------------------------------------------------