| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Failures in creating Oracle database file.
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.
-----Original Message-----
From: Jesse W. Asher [ SMTP:jasher1_at_tampabay.rr.com
<mailto:SMTP:jasher1_at_tampabay.rr.com> ]
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 jasher1_at_tampabay.rr.com
<mailto:jasher1_at_tampabay.rr.com>
--
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: Surendra.Tirumala_at_am.sony.com
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: ListGuru_at_fatcity.com (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). Received on Thu Nov 15 2001 - 09:07:11 CST
 |
 |