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

On Thu, 27 Jun 2002 17:28:04 GMT, "Joe Salmeri" <JoeSalmeri_at_comcast.net> wrote:

>I want option 1, files that are larger than 2 gb. I have tables that are
>much larger than 2 gb and I don't want tons of extents. I don't care about
>the things that don't understand large file support because I KNOW that
>Oracle does. I don't understand why this is such a difficult task to
>accomplish on Linux, I have done this on numerous Windows NT and Windows
>2000 servers that I have built over the years and it worked flawlessly.
>
>When you create a bunch of datafiles for a tablespace and that tablespace
>contains many large tables it is very easy to get into the situation where
>you are not be able to create objects because the free space is fragmented
>between all of the datafiles. This is not an easy thing to clean up and
>requires many hours of effort that could have EASILY been avoided.
>
>Extents (initial allocations or next allocations) MUST be contiguous.

Hear, hear.
That is why Oracle invented Locally Managed Tablespaces. This reduces fragmentation to exactly 0, that is when you allow for an extra 64k per file, holding the allocation bitmap. Objection overruled.

Regards

>cannot find free space in one datafile and combine that with free space in a
>second datafile to make up a SINGLE extent. If the extent size is not
>available in a contiguous block then the allocation fails.

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Thu Jun 27 2002 - 16:07:02 CDT