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: 2GB data file on Oracle 7.3.4

Re: 2GB data file on Oracle 7.3.4

From: Michel Cadot <micadot_at_netcourrier.com>
Date: 2000/07/12
Message-ID: <8khvjg$6cj$1@s2.feed.news.oleane.net>#1/1

You can create data files greater than your 982MB. I think you have to check oracle user limit with the command ulimit and set it to a greater value. Max is ulimit 2097151 on my system that is slightly less than 1GB.

--
Have a nice day
Michel


<faisal_qasim_at_writeme.com> a écrit dans le message : 8khtnn$hi3$1_at_nnrp1.deja.com...

> Dear all,
>
> I am getting error while trying to create 2GB Oracle 7.3.4 database
> file on AIX 4.3.3. While 982MB is the max. I could create.
>
> Is there a limit defined in Oracle and how can this be changed? Will it
> be beneficial to have one big file?
>
>
> Regards
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Wed Jul 12 2000 - 00:00:00 CDT

Original text of this message

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