Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i (8.1.7.0.1) + Redhat Linux 7.2 = Cannot create tablespace file > 2 gb

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

From: Liggs <liggs_at_hotmail.com>
Date: Sun, 4 Aug 2002 18:34:51 +0000 (UTC)
Message-ID: <aijs4b$3nc$1@helle.btinternet.com>


Er... what is wrong with having a tablespace with more than one datafile in it?
Are you planning on a very large database?

[Files more that 2Gb can cause problems on Intel based Windows BTW (in some cases!) - see Metalink ]

Liggs

"Fernando de Souza Lima" <flima_at_infolink.com.br> wrote in message news:3d4b3bfa.15235197_at_veloxnews.infolink.com.br...
> On Wed, 26 Jun 2002 15:59:18 GMT, "Joe Salmeri"
> <JoeSalmeri_at_comcast.net> 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?
> >
> >Thanks in advance.
> >
> >Joe
>
>
>
>
> Joe,
>
>
> I guess the problem is some kind of SO limitation. Search the RED HAT
> documentation about large files.
>
> I'll search for this information and send you back.
>
>
> Regards,
>
>
> Fernando Lima
> Commit Consulting
> ===================================
> OCP
> CCNA
> CNE
> CDIA
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> >
> >
> >
> >
>
Received on Sun Aug 04 2002 - 13:34:51 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US