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

From: <Jared.Still_at_radisys.com>
Date: Wed, 12 May 2004 15:20:43 -0700
Message-ID: <OF31AD5642.ED065DE4-ON88256E92.007A802B-88256E92.007ABFE3@radisys.com>

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_at_radisys.com
Sent by: oracle-l-bounce_at_freelists.org
05/12/2004 02:39 PM
Please respond to oracle-l

        To:     oracle-l_at_freelists.org
        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_at_freelists.org 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


-----------------------------------------------------------------

Received on Wed May 12 2004 - 17:17:59 CDT