RE: 2GB or not 2GB (datafile limit)? That is the question.

  • From: "Sweetser, Joe" <Joe.Sweetser@xxxxxxxxxxxxxxxx>
  • To: <Rich.Jesse@xxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Fri, 8 Sep 2006 07:35:51 -0700

About the only reason I have in the environment I work in is that we
copy a lot of database files between servers for test databases and
such.  Some of these copies occur over a WAN and, if a 20gb file gets
corrupted in the 19th gb (thereby necessitating another 20gb copy), it
can start to chew up some clock time.  With 10 2gb files, only another
2gb needs to be re-copied.  I suppose the same would hold true when
recovering a datafile/tablespace.

That said, I also have many larger datafiles (10-30gb) in some DBs and
have not any problems.  Environment is Windows (sigh), 8i, 9i, 10g.


> I don't see any need to limit the datafile size to 2GB anymore.
> else?
> TIA,
> Rich
> --
> //


Other related posts: