File write error on pipe export

From: Alex <avilner_at_gmail.com>
Date: 11 Jan 2006 20:49:44 -0800
Message-ID: <1137041384.675270.105290@g49g2000cwa.googlegroups.com>

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 Wed Jan 11 2006 - 22:49:44 CST