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: imp reading stdin ( UNIX )

Re: imp reading stdin ( UNIX )

From: Karsten Schmidt <0435280-8168_at_t-online.de>
Date: Wed, 14 Apr 1999 11:40:13 +0200
Message-ID: <3714627D.6DCD0FB5@t-online.de>


Hi Kevin,

Kevin Brand schrieb:
>
> The following works:
>
> exp parfile=xxx.par file=stdout | gzip >mydump.gz
>
> But I can find nothing that allows imp to read from stdin like this:
>
> gzip -c -d mydump.gz | imp parfile=xxx.par file=stdin
>
> I can create a pipe then filter all of the dump file through there, but this
> is slow. I'd rather implement this on the command line like this:

if you create a named pipe (mkfifo) you should get the same performance as the input redirection.

like
$ mkfifo mypipe
$ gzip ... > mypipe &
# don't know which parameret to use for gzip offhand $ imp .... file = mypipe

>
> exp parfile=xxx.par file=stdout | imp parfile=xxx.par file=stdin
>
> Why does exp recognize the standard unix notation for standard out while imp
> does not recognize standard unix notation for standard in??
>
> Any suggestions?
>

Karsten Received on Wed Apr 14 1999 - 04:40:13 CDT

Original text of this message

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