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

Home -> Community -> Usenet -> c.d.o.server -> Re: Using a pipe accross network with export/import

Re: Using a pipe accross network with export/import

From: Karsten Schmidt <groups_at_karsten-schmidt.com>
Date: 28 Aug 2003 05:56:01 -0700
Message-ID: <c6711ac4.0308280456.21df2218@posting.google.com>


Hi,
 I don't think it would work that way.

 here is what I usually do.

 export into a named pipe on the source host,  on the target host, create another named pipe,  start import to read from that second pipe,

 start a remote shell from target on source that cat's the source pipe to stdout, and redirect that into the target pipe.

Karsten

Rick Denoire <100.17706_at_germanynet.de> wrote in message news:<eicqkv49k71khdtfn7sl8l4o53url23ldv_at_4ax.com>...
> I am considering how to transfer a DB to a new platform minimizing
> downtime. I would start a full export of the source DB (8.1.7, Solaris
> 7) into a named pipe located on a NFS mounted LUN which belongs to the
> target DB (Oracle 9i, Linux/Intel). On the target DB side, the import
> job would read from the named pipe, so export and import will run in
> parallel.
>
> Is this feasible?
>
> Thanks
> Rick Denoire
Received on Thu Aug 28 2003 - 07:56:01 CDT

Original text of this message

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