Re: 2gb filesize, large disks and splitting tablespaces

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 - 03:13:07 CDT