Re: 2G limit on tablespaces

In article <D9q8EE.DHq_at_cbr.dit.csiro.au>, robertp_at_crux.csis.dit.csiro.au (Robert Andrew Power) says:
>
>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
>
>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>robert.power_at_dit.csiro.au Software Engineer
>
>CSIRO Division of Information Technology
>Canberra Laboratory
>PO Box 664 tel: +61 6 216 7039
>Canberra ACT 2601 AUSTRALIA. fax: +61 6 216 7112
>+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++

Take look at sys.dba_data_files to see what size Oracle actually makes the datafile. I bet its not 2,047,000,000 bytes.  

Scott Overby                              sds_at_dataplusnet.com