Re: &^@#%$@#%$ stinkin' oracle7 database

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 http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Other related posts: