Re: Oracle Exports and 2 GB file limitation

From: Andrew Babb <andrewb_at_mail.com>
Date: Fri, 14 May 1999 09:22:16 +0800
Message-ID: <373B7AC8.94AC1DCC@mail.com>

Hi,

Can't be certain about this one, but I seem to remember that 8i is now supporting the concept of exporting to a file name, with a suffix sequence number, and specifying the size of each portion.

This would be similar to an export to a pipe, which is being piped through SPLIT. Rgds
Andrew

Aspi Engineer wrote:

> Hi,
>
> We are running Oracle 8i on AIX 4.3 and wanted to find out if Oracle
> will allow you to export a table/file that is more than 2G in size. If
> yes, then what is the maximum file size that can be exported before I
> need to think about partitioning the database tables.
>
> Thanks
> Aspi Engineer
> aspi_engineer_at_striderite.com
Received on Thu May 13 1999 - 20:22:16 CDT