From: Halina Monka <hmonka@ibm.net>
Subject: Re: exports and files > than 2 Gigs
Date: 1997/07/07
Message-ID: <33C1155F.5F2E@ibm.net>#1/1
References: <01bc8a14$35edb0c0$7916a68f@rasputin>
Reply-To: hmonka@ibm.net
Newsgroups: comp.databases.oracle.server



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

The 2GB datafile limit is OS specific.
If your OS has such limit, you can : create Unix pipe ( mknod ), export
to pipe and import from this pipe - meanning you will be exporting and
importing same time. I use pipe to export / compress the backup export. 
Halina