Alex,
It's been a little while since I've used named pipes in Unix. If I
remember correctly, the writing process will be blocked until another
process reads from the FIFO pipe. Can you do a "tail -f <pipe_file>"
on the named pipe while the export is blocked and see if you get data
output to the screen and if the export process begins writing out data?
Good luck!
Jeff...
Alex wrote:
> Dear netters,
>
> We are trying to build a piped export/import of specific tables on
> Oracle 10g (AIX).
> I have followed the general recommendation of creating a FIFO pipe on
> the source machine:
>
> ----------
> - Source:
> ----------
> mknod FIFO.dmp p
>
> But when I go to do the actual export:
> exp u/p FILE=FIFO.dmp LOG=mylog.log yada, yada, yada...
>
> the process just sits there -- nothing showing in the output or the
> log. Hitting Ctrl-C reports back "unable to write to FIFO.dmp"... And
> prompts for the expdata.dmp instead, at which point the export runs
> fine (but, of course, this is not what we are looking to do):
> ---------------------------------------------
> Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.4.0
> - 64bit Production
> With the Partitioning, OLAP and Data Mining options
>
> ^C
> EXP-00028: failed to open FIFO.dmp for write
> Export file: expdat.dmp >
> ---------------------------------------------
>
> After issuing mknod, I also tried chmod 777 FIFO.dmp -- but with the
> same result...
>
> Any ideas would be greatly appreciated!!!
>
> Thank you in advance!
>
> --Alex
Received on Thu Jan 12 2006 - 06:43:50 CST
