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

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