Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: exports 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
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
Received on Mon Jul 07 1997 - 00:00:00 CDT