Re: Oracle 8.0.6/Solaris 2.6 import fails with EOVERFLOW

how did you manage to produce an export file over 2 GB in the first place ?

i'd suggest you try creating a pipe, starting the import to read from the pipe, and then using another process to copy the import file into the pipe.

you'll need to check the syntax for these statements, and for your o/s. (on hp-ux, it's the mkpipe command)

# create a pipe
mkpipe /dev/ora/expdat.dmp ...
chown oracle:dba /dev/expdat.dmp

# start import from the pipe
imp ... =/dev/ora/expdat.dmp ... &

# copy the export file to the pipe
dd if=/u01/myexportfile of=/dev/ora/expdat.dmp ibs=64k &

HTH "Mick Sheppard" <mick.sheppard_at_flutter.com> wrote in message news:9151523c.0105250137.6336a5ef_at_posting.google.com...
> We have a large (> 2GB) export file on Solaris 2.6 and Oracle 8.0.6
> fails with error DEC 79 (EOVERFLOW) when trying to import it.
>
> Running truss on the import the problem is that imp is using open
> rather than open64 to access the file. Other programs, more for
> example, open the file with open64 and can view the import file.
>
> Does anyone know of an easy way I can get the file imported? A neat
> way to split the import into two files would be okay I guess.
>
> We've opened an Oracle TAR on this but if anyone knows of a patch to
> imp that would help too.
>
> TIA,
>
> Mick Sheppard
>
> Senior System Administrator
> flutter.com
>
Received on Mon May 28 2001 - 14:36:45 CDT