I checked the ulimit and it is set to "unlimited" so I don't think that is the problem. I think it is a little more insidious than that....
Deshpande, Kirti wrote:
Sounds like a large file can not be created in the file system (the large
file option at FS level?) or your 'ulimit' is not set large enough to handle
large sized files.
- Kirti-----Original Message-----
From: Jesse W. Asher [SMTP:[EMAIL PROTECTED]]
Sent: Tuesday, November 13, 2001 9:35 PM
To: Multiple recipients of list ORACLE-L
Subject: Failures in creating Oracle database file.
I'm attempting to create a 3GB file on an XFS filesystem using Oracle 8i
running on RedHat 7.1 with a generic 2.4.10 kernel and I'm getting some
errors. Here's the command and output I'm getting:
CREATE TABLESPACE ALTUSER DATAFILE
'/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE AUTOEXTEND ON
NEXT 1280K
MINIMUM EXTENT 128K DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1
MAXEXTENTS 4096 PCTINCREASE 0);
CREATE TABLESPACE ALTUSER DATAFILE
'/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE
*
ORA-01119: error in creating database file
'/export/4/oracle/oradata/alt/data01.dbf'
ORA-27037: unable to obtain file status
Linux Error: 75: Value too large for defined data type
=========================================
Any ideas as to what could be causing this? I thought the file size limit
is 4GB which is why I made the file 3GB. Is this correct or am I missing
something?? Many thanks!!
--
Jesse W. Asher [EMAIL PROTECTED]
-- Jesse W. Asher
"They that can give up essential liberty to purchase a little temporary safety, deserve neither liberty or safety." - Benjamin Franklin
