Re: exports and files > than 2 Gigs

Carlos A. Gonzalez <carlos_a_gonzalez_at_us.dell.com> wrote in article <01bc8a14$35edb0c0$7916a68f_at_rasputin>...
> 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.

there is 2GB filesize limit on some unixes. which should not really prevent you from doing a full database export. just create a pipe and export to a pipe, and read from another end of the pipe using 'dd' command and save the output into multiple files. You can optionally compress the output on the fly. I'm doing this all the time.

Cordially,
Sergei

>
> 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
>
>
Received on Thu Jul 10 1997 - 00:00:00 CDT