bigfile @8k has max 32TB smallfile @8k has max 32GB On Wed, Sep 16, 2009 at 11:01 PM, hrishy <hrishys@xxxxxxxxxxx> 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 -- //www.freelists.org/webpage/oracle-l