In one of my previous assignments, even if my ulimit was unlimited, I could not create datafiles bigger than 2 GB, The OS was Sun Solaris 2.6. So best thing is to test what Kirti suggested. Thanks, Suren
-----Original Message----- Sent: Wednesday, November 14, 2001 12:25 AM To: Multiple recipients of list ORACLE-L 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] <mailto: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] <mailto:[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 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
