Re: max size of datafile

From: James Mu <jamesmu_ca_at_yahoo.ca>
Date: Mon, 07 May 2001 19:25:17 GMT
Message-ID: <xECJ6.40435$_f3.666814@news20.bellglobal.com>

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 Mon May 07 2001 - 14:25:17 CDT