Re: 2gb filesize, large disks and splitting tablespaces

Martin is right however the defining statement on this topic and be found in Metalink DOC ID :Note:62427.1

"Martin Haltmayer" <Martin.Haltmayer_at_0800-einwahl.de> wrote in message news:3B232C13.BBCF443C_at_0800-einwahl.de...
> This is simple not true. We have our data files 10 GB each and it works
 nicely
> with 32-bit Oracle 8.1.6.3.0 for Sparc Solaris.
>
> Martin
>
>
>
> John Morais wrote:
> >
> > Oracle Supports to GB files if not running 64 bit OS. If you want to go
 over
> > 2GB files then you need 64bit OS and 64bit Oracle. If your mount points
 are
> > under Veritas control you must also enable largefiles for the FS.
> > "Yong Huang" <yong321_at_yahoo.com> wrote in message
> > news:b3cb12d6.0106061231.15306c47_at_posting.google.com...
> > > I want to take back the following words. A 32-bit binary number filled
> > > with "1" is 4G, not 2G (which is 31 bits of "1"s), and there's too
> > > much guess work.
> > >
> > > Yong Huang
> > > yong321_at_yahoo.com
> > >
> > > yong321_at_yahoo.com (Yong Huang) wrote in message
 news:<b3cb12d6.0106061005.1939af0_at_posting.google.com>...
> > > > Generally, it's a good idea of using files smaller than 2GB. Think
> > > > about it. 2G, or 2 x 10 [sup]9, corresponds to a 32-bit number all
> > > > filled. Even if the mount command says your filesystems have the
> > > > option largefiles enabled, how about Oracle? If Oracle binary,
> > > > $ORACLE_HOME/bin/oracle, supports large files (file oracle on
> > > > Solaris), how about any utility under $ORACLE_HOME/bin? There're too
> > > > many possibilities, even at OS level (is your OS 64-bit?).
Received on Sun Jun 10 2001 - 08:16:43 CDT