Re: Someone from Oracle says not oficially windows has problem with datafiles bigger than 1 GB???

file size of 16384 MB on NT4 with 4 KB block size is a problem. Some bugs are known for datafiles of exact multiples of 2 GB (especially 4 GB). 1 GB datafiles are manageable and compress nicely. (mee tooo)

Pd

On Tue, 28 Sep 2004 12:46:17 -0700, Wolfgang Breitling <breitliw_at_centrexcc.com> wrote:
> Windows has problems managing just about anything, particularly security. :-(
>
> I am not aware that its problems managing datafiles larger than 1GB are any
> bigger than any of its other problems.
> I have datafile larger than 1G in my windows instances, but then they are not
> production and don't encounter heavy usage.
>
> However, unless your databases are in the terabyte category - which I
> definitely wouldn't entrust to windows, I would keep datafiles under 2G
> regardless of OS.
>
> Quoting Juan Carlos Reyes Pacheco <jreyes_at_dazasoftware.com>:
>
> > Hi list
> > Please my customer received one email asking to resize a datafile
> > and he said
> > "According to the email you sent the datafile affected has a size more than
> > 1gb, that could be causing the problem, because windows operating system has
> > problems managing datafiles bigger than 1GB. .... This information is not
> > official."
> >
>
> --
> regards
>
> Wolfgang Breitling
> Oracle 7,8,8i,9i OCP DBA
> Centrex Consulting Corporation
> www.centrexcc.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>

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