Re: Max. size of Oracle data file(B
Date: Sat, 21 Feb 2009 08:14:13 -0800 (PST)
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:
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
IT Manager/Oracle DBA
K&M Machine-Fabricating, Inc. Received on Sat Feb 21 2009 - 10:14:13 CST