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

.. and if the listening side is on a different server ?

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]On Behalf Of
Jared.Still@xxxxxxxxxxx
Sent: Wednesday, May 12, 2004 4:39 PM
To: oracle-l@xxxxxxxxxxxxx
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
------------------------------






Jared.Still@xxxxxxxxxxx
Sent by: oracle-l-bounce@xxxxxxxxxxxxx
 05/10/2004 02:37 PM
 Please respond to oracle-l

 
        To:     oracle-l@xxxxxxxxxxxxx
        cc: 
        Subject:        Re: &^@#%$@#%$ stinkin' oracle7 database


> Can you post an example script? Netcat is so generic that it is 
disgusting.
> On 05/10/2004 02:05:11 PM, Jared.Still@xxxxxxxxxxx wrote:
> > Use netcat for pipes between machines.
> -- 
> Mladen Gogala

I'll post one in the next day or two.

Jared




----------------------------------------------------------------
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
-----------------------------------------------------------------




----------------------------------------------------------------
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
-----------------------------------------------------------------

----------------------------------------------------------------
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: