Re: linux 2gb limit

From: GC <johnny_sanga_at_hotmail.com>
Date: Sun, 09 Jan 2000 23:31:17 GMT
Message-ID: <38791AC4.6F4C636E@hotmail.com>

Harald Wakonig wrote:
>
> Hi,
>
> > Does anyone havea good approach to managing oracle with linux and its 2gb
> > file limitation? What are people doing?
>
> Where is the problem ?
>
> Even the size of one single table is NOT limited by the maximum file
> size. A
> table or an index just needs to fit into one Oracle-tablespace, which
> can
> consist of many 2 gb files ...

If you really want a file larger than 2 gb, there is a patch (I don't have the url handy, but a search of various linux sites should turn something up) that will bump the supported file size up. One caveat, I do believe this is a patch from the current devel kernel, and may not be something you want to use in a critical production environment. The 2.4 kernel series (when it is out, which should be RSN), is slated to support >2gb files.

Cheers,
GC Received on Sun Jan 09 2000 - 17:31:17 CST