Re: Limit for EXPORT dmp file?

try /usr/sbin/mknod (maybe as root if necessary).

Also, you should put the 'compress ...&' statement before the EXP (otherwise, you will only start compressing once you've finished exporting).

"JK Yao" <jkyf0131_at_hotmail.com> wrote in message news:93f65984.0107151827.4a9f624a_at_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 Mon Jul 16 2001 - 05:23:08 CDT