Re: 2G limit on tablespaces

Robert Andrew Power (robertp_at_crux.csis.dit.csiro.au) wrote:
: 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?

There is a 2G limit on a file on most Unix systems. You can, however, add more files to a tablespace to make it larger than 2G.

--
           ___  Oo            .:/
          (___)o_o         ,,///;,   ,;/
     //====--//(_)        o:::::::;;///         Ron Ross           
             \\ ^        >::::::::;;\\\         <rross_at_langara.bc.ca>
                           ''\\\\\'" ';\        I'd rather be diving !!!