Re: Oracle 8 on AIX: size of datafiles

From: <ioulian_at_my-deja.com>
Date: Sat, 12 Jun 1999 02:01:12 GMT
Message-ID: <7jsf14$vgr$1@nnrp1.deja.com>

Just hit the same problem. Check the ulimit file size. Also, in SMIT: Security&Users,Soft File Size Limit.

Ioulian.

In article
<928862443.20785.0.pluto.d4ee154e_at_news.demon.nl>, "Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote:
> Hi Eduard
> Look at the configuration of your logical
volumes, to things like number of
> i-nodes,
> number of logical partitions etc. This must be
a jfs issue, as Oracle itself
> can create 2Gb files!
>
> Hth,
> Sybrand Bakker, Oracle DBA
>
> Eduard Erhart wrote in message

<375D4D73.53517F7E_at_at.ibm.com>...
> > Hi all !
> >
> >I have on Oracle 8 server installed on aix
4.3.2.
> >
> >I am not able to create a datafile for a
tablespace more than 1GB in
> >size using create tablespace ....
> >
> >The oracle user itself can produce files up to
2GB using AIX commands.
> >
> >On a second Oracle8/AIX 4.3.2 server I have no
problem to do that.
> >
> >I can't find the different!
> >
> >Any hints ???
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri Jun 11 1999 - 21:01:12 CDT