Re: Export and files > 2Gigs

On 6 Jul 1997 13:50:41 GMT, "Carlos A. Gonzalez" <carlos_a_gonzalez_at_us.dell.com> 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
>
>Carlo

From my experience of Solaris the actually default max file size is about 1.7Gb with an overhaed added. I know the overhaed can be reduced to give a 2.0Gb file. The only suggestion I have is to export the biggest table separately and then drop it and export the full database. If this is still to big then you will have to run 2 or 3 expports using a parfile. I think the max no of tables is just short of 100.

John Hallas jhalla_at_premier.co.uk Received on Sun Jul 06 1997 - 00:00:00 CDT