Re: Export File Size 2G limit

Patrick Elliott wrote:
>
> We are looking into the possibility of exporting upwards of 40G of
> data from one of our databases. The biggest table is 30G, therefore
> we can't export by table due to the unix 2G file size limitation. I
> was thinking about the possibility, however of exporting to a named
> pipe, starting a dd on that named pipe that is piped to a compress
> that in turn is piped to a C program to monitor the size of the input
> and spit out the data to multiple files when the limit of 2G is
> reached. If anyone has experience with this, I would appreciate some
> feedback. Ideally I would like to get at some existing C code to do
> this for us if possible.

One option is to export directly to tape. Assume the tape device is "/dev/rmt0" and you're doing a full export. Use this:

exp scott/tiger full=y file=/dev/rmt0 volsize=2000M

Once the export utility has written {volsize} to tape it will prompt for the next tape. I believe there is still a limitation of 2 Gig per tape during the export. Received on Wed Nov 13 1996 - 00:00:00 CET