Re: File write error on pipe export

From: Alex <avilner_at_gmail.com>
Date: 12 Jan 2006 05:54:01 -0800
Message-ID: <1137074041.072269.26660@f14g2000cwb.googlegroups.com>

No such luck -- tail -f shows nothing....

Session monitor shows there is an export going. And IO on the session is changing (consistent gets, etc.), so the export session is active. For some reason, though, it is unable to write to a file.

It goes through the entire export, and fails at the end, still unable to write to the file:
About to export specified tables via Direct Path ...

. . exporting table              mytablename
...........................................................................
...........................................................................
...........................................................................
...........................................................................
...........

EXP-00002: error in writing to export file EXP-00002: error in writing to export fileerror closing export file FIFO.dmp
EXP-00000: Export terminated unsuccessfully

Jeff wrote:
> 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 - 07:54:01 CST