Re: Exporting huge tables from Oracle 8.0.5

"Tomasz Olczak" <olczak_at_ipartners.pl> wrote in message news:3A277CC1.896DD9E7_at_ipartners.pl...
> Dear Everybody,
>
> I was trying to export a huge table (around 3.5GB of total extents) to a
> file using Oracle export utility and I got this error message:
>
> EXP-00002: error in writing to export file
> EXP-00222: System error message 5
> EXP-00000: Export terminated unsuccessfully
>
> I repeated the try but it finished the same way. It is interesting that
> both times it happened at the moment the export file grew to 2147483647
> bytes. I have enough free space on the disk so I was thinking that maybe
> it is some OS limitation (I run on Solaris 2.6)?
> But on the other hand one Oracle datafile on the same machine has
> already exceeded 5.7GB.
> What could be the reason than?

Earlier versions of Export have a 2Gb filesize limit (there may be a patch for this from Oracle). If large file sizes are enabled on your OS, and it sounds like they are, try exporting to a named pipe. The pipe always has a zero file size and this 'fools' Export.

mknod export_pipe p
compress < export_pipe > export.dmp.Z
exp / file=export_pipe etc........

Regards

Nick Received on Sun Dec 03 2000 - 11:38:39 CST