Re: "Headroom" in datafiles?

Thanks for clarification

• On Thu, 17/9/09, Greg Rahn <greg_at_structureddata.org> wrote:

> From: Greg Rahn <greg_at_structureddata.org>
> Subject: Re: "Headroom" in datafiles?
> To: hrishys_at_yahoo.co.uk
> Cc: Mark.Bobak_at_proquest.com, ChrisDavid.Taylor_at_ingrambarge.com, oracle-l_at_freelists.org, Richard.Goulet_at_parexel.com
> Date: Thursday, 17 September, 2009, 7:05 AM
> bigfile _at_8k has max 32TB
> smallfile _at_8k has max 32GB
>
> On Wed, Sep 16, 2009 at 11:01 PM, hrishy <hrishys_at_yahoo.co.uk>
> wrote:
> > Hi
> >
> > Are the docs wrong ?
> >
> > http://www.stanford.edu/dept/itss/docs/oracle/10g/server.101/b10739/tspaces..htm#i1010733
> >
> > quote
> > A bigfile tablespace with 8K blocks can contain a 32
> terabyte datafile
> > quote
> >
> > My impression is that for 8k block size the size of
> the datafile is 32gb
>
> --
> Regards,
> Greg Rahn
> http://structureddata.org
>
      

--
http://www.freelists.org/webpage/oracle-l