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

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. It 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.

"Liggs" <liggs_at_hotmail.com> wrote in message news:afdf4b$hsj$1_at_paris.btinternet.com...
> What do you want?
> 1) files that are larger than 2 Gb (why ?)
> 2) tablespaces that can hold more than 2 Gb?
>
> if 1 then :-
> you need to enable large file support, but lots of things do not
> 'understand' large files. Its a bit of a vague area.
>
> if 2 then :-
> A tablespace can be bigger than 2Gb, if you run up against a 2Gb file
> limit, then add another datafile to the tablespace
> alter tablespace X add datafile '/f/f/f/f/f.dbf' size 2000m;
>
> It sounds like it would be safer support wise to go with option 2, you end
> up with the same capacity (add lots of datafiles) and its
> less risky.
>
> Liggs
>
> "Knut Talman" <knut.talman_at_mytoys.de> wrote in message
> news:3D19E847.C332F221_at_mytoys.de...
> > Joe Salmeri wrote:
> > >
> > > Here is the server configuration:
> > >
> > > Dual P3 Dell Server with 1.5 GB RAM
> > > Redhat Linux 7.2
> > > Oracle 8i (8.1.7.0.1)
> > > Two Oracle databases created
> > > Oracle TNS Listener configured
> > >
> > > Everything appears to be working properly with both database
instances,
> > > however we are unable to create a tablespace file that is larger than
2
> GB.
> > >
> > > I know that Oracle 8i supports tablespace files that are larger than 2
> GB
> > > because I have setup Oracle 8i installations on Windows 2000 and have
> > > created > 2gb tablespace files.
> > >
> > > From the Redhat website I see that there is a version called Redhat
> > > Enterprise Edition that says it has largefile support for Oracle 8i,
but
> is
> > > it possible without getting the Enterprise Edition? If so, what needs
> to be
> > > done to provide that support?
> >
> > There are tons of documentation about large file support out there. Just
> google
> > to find it.
> >
> > Regards,
> >
> > Knut
>
>
Received on Thu Jun 27 2002 - 12:28:04 CDT