Re: 2G limit on tablespaces

In article <3r4tug$ja2_at_inet-nntp-gw-1.us.oracle.com>, cgohring_at_reebok (Carl Gohringer) wrote:

> robertp_at_crux.csis.dit.csiro.au (Robert Andrew Power) writes:
> : I've just installed Oracle 7.1.6 on a SPARC 20 Dual Processor
> : with a 6Gb Storage Array running Solaris 2.4.
> :
> : When I create a tablespace of size 2048M it fails, but if I
> : create one of size 2047M everythings fine.
> :
> : Is there a 2G limit on creating tablespaces in the documentation and
> : I've missed it - or is somethng weird going on with my installation?
> :
> : Robert Power
> :
>
> Exactly what does "Falling over" entail?
> Any error numbers?

This makes a great deal of sense - isn't this operating system (like most flavors of unix) limited to 2gb maximum file size ? When you create a tablespace, there is some room (2 database blocks ? check with Oracle Support for exact size) reserved for file and/or tablespace header information:
2048M + 2 blocks > than O/S max file size = error.

You could use bytes as the unit to specify the initial file size and not waste a whole megabyte. Also note that the 2gb size limitation is per operating system file and not per tablespace - a tablespace can have many many data files associated with it.

P.S. As Carl stated, the exact error messages in pleas for help like this would be useful... Received on Wed Jun 07 1995 - 00:00:00 CEST