Re: file size limitations?

It is correct that the exp and imp utilities have a 2 Gb file size limit, however several workarounds to break this limit exist (by using stdin/stdout mechanism).

Regarding using datafiles larger than 2 Gb I usually recommend that unless you have a specific need for such large files, don't use them! - at least, not in a production environment. There has been (and might still be) numerous bugs (OS and Oracle) related to this, so let the others find them (while you can run on your stable <2Gb files :-).

Cheers,
Gollum

On Fri, 4 Feb 2000 14:06:25 GMT, Brian Peasland <peasland_at_edcmail.cr.usgs.gov> wrote:

>Solaris 2.6 doesn't have a 2GB, but the Oracle software might. On my Sun
>boxes, I can create a file larger than 2GB. But the export utility
>can't. So when I export, I have to compress the file through a pipe.
>When I do this, I'm bypassing Export's writing to disk. It's writing to
>a pipe and the file can be much bigger.
>
>Anyway, to be sure that one of your tablespaces doesn't run out of room
>and doesn't hit a 2GB file size limit, just add another datafile to the
>tablespace.
>
>HTH,
>Brian
>
>Nuno Souto wrote:
>>
>> On Thu, 3 Feb 2000 09:51:08 -0500, "Jim Day" <jday_at_fslso.com> wrote:
>>
>> >in size. Is there a size limitation for any single *.dbf Oracle file on
>> >Solaris 2.6 (I thought I read once there was a 2GB file size limitation)?
>>
>> Probably yes. Most older UNIX implementations have that limit. Dunno
>> if Sol2.6 does.
>>
>> >If so, 1) can someone point me to documentation on this restriction,
>>
>> man ioctl(), read, follow the Related fields to write().
>>
>> > and 2)
>> >what are my options?
>>
>> a) Add more files of <2Gb size to your tablespace. You can add
>> many,many more without hitting problems. The maximum capacity of your
>> tablespace will be the sum of the sizes of all these files.
>>
>> b) Upgrade the OS and use larger files. You need to export/import the
>> tablespace to move it to a larger file.
>>
>> Pick the one that makes sense to you.
>>
>> HTH
>>
>> Cheers
>> Nuno Souto
>> nsouto_at_nsw.bigpond.net.au.nospam
>> http://www.users.bigpond.net.au/the_Den/index.html
>
>--
>========================================
>Brian Peasland
>Raytheons Systems at
> USGS EROS Data Center
>These opinions are my own and do not
>necessarily reflect the opinions of my
>company!
>========================================
Received on Fri Feb 04 2000 - 15:13:49 CST