Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Limit for EXPORT dmp file?
Thanks for you all,
I already solve this problem by using pipe.
% mknod /tmp/exp_pipe p # Make the pipe% compress < /tmp/exp_pipe > export.dmp.Z & # Background compress % exp file=/tmp/exp_pipe <other options> # Export to the pipe
Thanks again.
JK
mark.powell_at_eds.com (Mark D Powell) wrote in message news:<178d2795.0107160346.44319f6e_at_posting.google.com>...
> jkyf0131_at_hotmail.com (JK Yao) 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
>
> On my system the syntax is " mknod filename p "
> You should check your man pages to see what the syntax is on your system.
>
> -- Mark D Powell --
Received on Mon Jul 16 2001 - 22:04:26 CDT