Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: 2GB data file on Oracle 7.3.4
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...Received on Wed Jul 12 2000 - 00:00:00 CDT
> 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.