Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: &^@#%$@#%$ stinkin' oracle7 database

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

From: Ravi Kulkarni <kulkarni.ravi_at_heb.com>
Date: Wed, 12 May 2004 17:37:14 -0500
Message-id: <0HXM00K0WHHXFX@sys98049.heb.com>


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

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]On Behalf Of Jared.Still_at_radisys.com
Sent: Wednesday, May 12, 2004 4:39 PM
To: oracle-l_at_freelists.org
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_at_radisys.com
Sent by: oracle-l-bounce_at_freelists.org
 05/10/2004 02:37 PM
 Please respond to oracle-l  

        To:     oracle-l_at_freelists.org
        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_at_radisys.com 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_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
-----------------------------------------------------------------




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

----------------------------------------------------------------
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:34:23 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US