Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Limit for EXPORT dmp file?

Re: Limit for EXPORT dmp file?

From: JK Yao <jkyf0131_at_hotmail.com>
Date: 16 Jul 2001 20:04:26 -0700
Message-ID: <93f65984.0107161904.7a49c837@posting.google.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US