Hi All,

I am new to both Oracle 9i and AIX 5.
When I try to create Table space with fiove data files @ 2GB, I get
error saying that the size of my datafile exceed maximum allowed
(forget to note the exact err msg).
So that I must create 10 datafiles @1 GB.

Maximum datafile in UNIX is 2 GB, isn't it ?
Is there any setting here ?

Thank you for any help,
Krist

> I am new to both Oracle 9i and AIX 5.
> When I try to create Table space with fiove data files @ 2GB, I get
> error saying that the size of my datafile exceed maximum allowed
> (forget to note the exact err msg).
> So that I must create 10 datafiles @1 GB.


man ulimit

Raise the limit for oracle's O/S user.
For files greater 2G the filesystem(s) must be created with large files
enabled. If both conditions are met, you can create datafiles as large
as you've set ulimit.

Doesn't sound like a small-play-around-only database.
It is recommended to spread roll-back, redologs, data and indicees over
different physical disks whenever possible.
The database the oracle installer creates is a worst case example.

--


Uli

(Reply to ulrich <dot> link <domain-delimiter> epost <dot> de)

Hello,

> Maximum datafile in UNIX is 2 GB, isn't it ?
> Is there any setting here ?
Yes and no. On AIX/jfs the maximum is 1GB if you didn't enable support for large files when creating the filesystem. I don't know how it is in newer versions of AIX but on 4.3 you can't change this without re-creating the filesystem.

good luck
Michael

Macallan wrote:
>> Maximum datafile in UNIX is 2 GB, isn't it ?
>> Is there any setting here ?
>
> Yes and no. On AIX/jfs the maximum is 1GB if you didn't enable support
> for large files when creating the filesystem.

Um, that's incorrect. The max filesize on JFS is 2 GB without
large file support. The default filesize ulimit is 1 GB, which
you'd have to modify to be able to get to the 2 GB limit. IIRC
JFS2 avoids the 2 GB limit, but RTFM.

--
Gary R. Hook / AIX PartnerWorld for Developers / These opinions are MINE
__________________________________________________ ______________________