Re: export and files > than 2 Gigs

Hein wrote:
>
> 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

A quick hack is to run several exports instead of one each with only some of the tables...

Cheers
Connor

-- 
Connor McDonald
Systems Administrator-Unix/Oracle
BHP Information Technology
("These views are mine not BHPIT blah blah")
"You're not drunk if you can lie on the floor without holding on"
            - Dean Martin