RE: Max File Size?
- From: "Rich Jesse" <rjoralist3@xxxxxxxxxxxxxxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Mon, 25 Aug 2014 14:13:15 -0500 (CDT)
Joe posted:
> 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:
//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...
--
//www.freelists.org/webpage/oracle-l
Other related posts:
