Re: Max. size of Oracle data file

From: Jack <>
Date: Mon, 23 Feb 2009 07:34:21 GMT
Message-ID: <1ksol.27$>

"Ming?" <> wrote in message
> Anyone know the max. size of Oracle data file in Windows Server with
> NTFS? 32G? or depends on block size of instance?
> Ming

Oracle 10G introduced a new type of tablespace called a Bigfile Tablespace. Bigfile Tablespaces
The maximum size of the single datafile or tempfile is 128 terabytes (TB) for a tablespace with 32K blocks and 32TB for a tablespace with 8K blocks. Received on Mon Feb 23 2009 - 01:34:21 CST

Original text of this message