Re: 2Gb Exp problems 8.1.7

Information Services wrote:

> Information Services wrote:
>
> > I know that there were issues with Oracle 7 export and the 2Gb file
> > limit, are they still there with 8.1.7?
> > I'm having problems with my export, and although I'll be hassling the
> > sysadmins about it, I need to know if its a problem at the oracle end.
> > OS is Sun Solaris 8.
> > Thanks
> > Geoff
> > Geoff Reader
> > Admin Computing
> > University of Brighton
>
> The errors I'm getting are EXP-00015 and EXP-00002, and when I look at the
> file size using ls -l, I see 2Gb. I saw the metalink article quoted by
> peter which referred to Oracle 7, and I wondered if this is still an issue
> for 8i.
> Strangely in the space of a week, I'm getting the same problem on an old
> 7.3.4 instance and a 8.1.7 instance.
> I've spoken to the sysadmins now, and they have set up (brand new 880's -
> doh!) the servers' filesystems with large files disabled. While they try
> and sort out something I need a work around, as my exports are not good.
> Everything I need is being backed up, but when I run an import it hangs
> after importing the data, it seems confused as the file end isn't there.
> Setting multiple files in the par file seems the way, forward, I'll look
> into that. I hadn't noticed that when I'd looked in the past. Seems a
> lot easier than named pipes (as recommended by Tom Kyte).
> Thanks
>
> Geoff
> Geoff Reader
> Admin Computing
> University of Brighton

2GB file limit sizes are often an operating system limitation whether Oracle can or can not write larger.

Daniel Morgan Received on Thu Feb 13 2003 - 10:46:42 CST