Re: 2GB data file on Oracle 7.3.4

From: Steve McDaniels <steve.mcdaniels_at_sierra.com>
Date: 2000/07/13
Message-ID: <8kl3gv$kfm$1@spiney.sierra.com>#1/1

On my HP-UX 11 (32-bit)
I have a 2G file limit (imposed by unix).

One can also set a file limit on a per user basis (not exceeding the 2Gb unix limit)

This may be overly obvious, but is there more than 982Mb AVAILABLE on the drive/volume?

<faisal_qasim_at_writeme.com> wrote in message news: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 Thu Jul 13 2000 - 00:00:00 CDT