Re: Max. size of Oracle data file(B

From: Charles Hooper(B <hooperc2000_at_yahoo.com>
Date: Sat, 21 Feb 2009 08:14:13 -0800 (PST)
Message-ID: <ea452cb8-dd1e-4e03-a28d-052a0c7c2fc4_at_b40g2000pri.googlegroups.com>



On Feb 21, 10:35 am, Ming$BGl(B <l..._at_tech-trans.com> wrote:
> On 2$B7n(B20$BF|(B, $B2<8a(B11$B;~(B14$BJ,(B, Charles Hooper <hooperc2..._at_yahoo.com> wrote:
> > 32G with 8KB database blocksize, unless...
>
> > (A Google search will help you find the rest of the above statement,
> > and it is potentially version dependent.)
>
> > Charles Hooper
> > IT Manager/OracleDBA
> > K&M Machine-Fabricating, Inc.
>
> How about the max. size of datafile in Oracle 64bit Windows?
> 32G or more if 8k block is used?

32GB per datafile (may use multiple datafiles per tablespace if needed) on Windows 2003 x64 using NTFS running Oracle 10.2.0.x when an 8KB block size is used for the tablespace, unless...

A Google search to help:
http://www.google.com/search?q=site%3Adownload.oracle.com+datafile+maximum+102

Currently, the first page returned by the above: http://download.oracle.com/docs/cd/B19306_01/server.102/b14220/physical.htm#i14068

Currently, the sixth page returned by the above: http://download.oracle.com/docs/cd/B19306_01/server.102/b14237/limits002.htm

Charles Hooper
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Sat Feb 21 2009 - 10:14:13 CST

Original text of this message