Re: max size of datafile

The maximum file size depends on a number of things. First of all the number of blocks that Oracle can address in a file. A Data Block Address contains of 32 bits. In Oracle8 and Oracle7 the number of bits allocated for files was 10 and 22 for blocks. So you can have 2^22 blocks * 32K blocksize is the maximum that a file can be. Ofcourse OS limitations will reduce that further down. In Oracle7 there could be only 2^10 files for the whole database. In Oracle8 that is 2^10 files per tablespace.

Anjo.

James Mu wrote:

> hi,
> Oracle hasn't limitation about file size. The limitation roots from the
> O.S. Generally it has a 2G limit except for the filesystem supporting large
> files. If you have enough disks, making serveral datafiles separately is a
> good choice.
> andy <news_at_info-line.it> wrote in message
> news:3af6632c.7017210_at_news.cis.dfn.de...
> > I have an Oracle 7.3.4 database under Sco Unix Openserver 3.2 5.0. The
> > db_block_size parameter is set to 2048.
> > What is the maximum size reachable of one datafile?
> >
> > Thanks in advance.
> >
> > Andy.
Received on Wed May 09 2001 - 11:34:53 CDT