Re: Data file size limit

From: Yong Huang <yong321_at_yahoo.com>
Date: 22 Jul 2002 15:00:30 -0700
Message-ID: <b3cb12d6.0207221400.5eaa6a4e@posting.google.com>

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> I remember seeing docs from Oracle stating on a 32-bit o/s the limit of a
> file is 2G. I'm not sure why you contradict information in the docs.
>
> Regards

Hi, Sybrand,

The generic documentation (References -> Physical Database Limits) says:

Database file size
Maximum
Operating system dependent. Limited by maximum operating system file size; typically 222 or 4M blocks.

32-bit OS does not necessarily limit OS filesize to 2GB or 2**31 (because you can use direct blocks, indirect blocks, double indirect and triple indirect blocks to contain file pointers). File systems can be created with largefiles option. mount(1) tells you which one has that enabled.

Yong Huang Received on Mon Jul 22 2002 - 17:00:30 CDT