RE: Max File Size?

> I am running 11.2.0.2 on RH 5 without any special settings/configs. Oracle
> seems to be pretty unhappy when an individual file gets over 32gb.
>
> alter database datafile '/u02/oradata/joedb/being_silly_01.dbf' resize
> 33056m
> ORA-1144 signalled during: alter database datafile '/u02/oradata/
> joedb/being_silly_01.dbf' resize 33056m...

Something about "cannot remember the past" and "condemned" come to mind:

http://www.freelists.org/post/oracle-l/2GB-or-not-2GB-datafile-limit-That-is-the-question

My 8K blocksize tablespaces have datafile sizes limited to 31GB in 11.2.0.3.  That should still get me as many 100s of TB as I'll need for the foreseeable future. :)

Rich

Disclaimer: I'm probably still somehow condemned, though...

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