Re: Limit for EXPORT dmp file?

"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 Sat Jul 21 2001 - 16:37:23 CDT