Re: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb

"Howard J. Rogers" wrote:
>
> Why on Earth anyone would want files bigger than 2Gb, I can't imagine.

Because, maybe, they have 12 TB databases which would require 6000 datafiles to manage if they were only 2 GB apiece? You can start hitting OS barries with that many datafiles, like openfiles or, in our case, nflocks since we're on a NAS.

> Tablespaces should get bigger by having more files, not huge, monolithic
> entities that have to be backed up in their entirety, restored in their
> entirety, and in which all data is lost until the entire thing is restored
> and recovered.

Generally true for smaller databases, agreed. But sometimes you need the space.

Regards,
Sean M Received on Fri Jun 28 2002 - 11:27:41 CDT