Re: max size of datafile

Connor McDonald wrote:

> andy wrote:
> >
> > I have an Oracle 7.3.4 database under Sco Unix Openserver 3.2 5.0. The
> > db_block_size parameter is set to 2048.
> > What is the maximum size reachable of one datafile?
> >
> > Thanks in advance.
> >
> > Andy.
>
> Many different limits apply - my personal opinion that any datafile over
> 2g starts to be a problem due to any of:
>
> - OS restrictions
> - file system restrictions
> - oracle bugs
> - pain in the arse to move around easily
>
> hth
> connor
> --
> ===========================================
> Connor McDonald
> http://www.oracledba.co.uk (mirrored at
> http://www.oradba.freeserve.co.uk)
>
> "Some days you're the pigeon, some days you're the statue"

I just built an instance yesterday with quite a number of 6GB tablespaces. Wasn't the first time. Won't be the last. Solaris 2.8 is perfectly happy as is Oracle 8.1.7.1.0. But then what else are you going to do with a Sun e450 with 20 x 9GB drives?

Can't speak to how Windows would handle it.

Daniel A. Morgan Received on Wed May 09 2001 - 00:47:25 CDT