Re: export and files > than 2 Gigs

Carlos A. Gonzalez wrote:

> Gentlemen:
> Here is what's happening.
> I am in the process of movin a large database (20 Gigs) from one host
> to
> another.
> The export file I'll be creating is over two Gigs space.
> The Oracle Gurus at my site tell me about a unix file size limitation
> that
> can not be greater than 2 Gigs.
> I'm skeptical, specially since I been told a lot of misinformation
> from the
> same people before.
> I am running oracle ver 7.2.3 under unix Solaris ver 5.2 in Sun Sparc
> hardware
> Any help/comments/leads will be greatly appreciated
> Thanks
> Carlos

 Most of the later releases of UNIX now support files > 2Gig . I dont know which version on Sun does though. Your other problem is that the export utility cannot WRITE files bigger than 2Gig
There is however patches available for the 7.3 version of Oracle to export large files.
The best would be to get the releases of Solaris that support > 2Gig files and find out from Oracle if a patch is available for 7.2 to export Large files.

Thanks
Hein Received on Tue Jul 08 1997 - 00:00:00 CEST