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

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:gfvmhusfooj1enmi8r96k7k3drcfpfd5im_at_4ax.com...
> 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. \

Extents can never be contiguous when using file systems. Ever. Not physically. But that's a side issue.

You are starting from a false premis and compounding it thereafter. A large number of extents (say 1000 or so) in locally managed tablespace is not an issue. Therefore, the size of the extents does not have to be humungous. Therefore, neither do the datafiles.

HJR
>
> 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 Fri Jun 28 2002 - 05:00:27 CDT