Re: Limit for EXPORT dmp file?

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 15 Jul 2001 19:27:43 -0700
Message-ID: <93f65984.0107151827.4a9f624a@posting.google.com>

hi,

When I execute mknod, it shows that I am not be able to execute mknod.  Is that any problem with the shell?
Following is the error mesg.

---

oracle_at_P2000> mknod -p orapipe
ksh: mknod: cannot execute

---

Thanks for any help,

regards,
JK

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<tkvr2vch4du124_at_beta-news.demon.nl>...
> "JK Yao" <jkyf0131_at_hotmail.com> wrote in message
> news:93f65984.0107132237.33528bfd_at_posting.google.com...
> > Is there any file size limit for Export dmp file?
> > Why when I export to a talbe and then it terminate...? Follow is the msg:
> >
> >
> > . . exporting table INV_ACCOUNTING_ROW_TAB
> > EXP-00002: error in writing to export file
> > EXP-00002: error in writing to export file
> > EXP-00000: Export terminated unsuccessfully
> >
> > What is the possible factor to make this happen?
> > Any hint will be very appreciated.
> >
> > Thanks in advance,
> >
> > JK
>
> O/S dependent there may be a 2 G limit.
> As you are stuck with 7.3.4, you can't resolve this by changing export
> parameters (one reason to upgrade!)
> and you need to use the the tric with to compress the file on the fly by
> using a pipe.
>
> The basic outline of this is
> mknod -p orapipe
> exp ..... file=orapipe
> compress < orapipe > <dumpfile>.Z &
>
> More info most likely on Metalink and/or the Asktom site.
>
> Hth,
>
> Sybrand Bakker, Senior Oracle DBA
Received on Sun Jul 15 2001 - 21:27:43 CDT