Re: Failures in creating Oracle database file.

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 largefile option at FS level?) or your 'ulimit' is not set large enough to handlelarge sized files. - Kirti   

    -----Original Message-----From:	Jesse W. Asher [SMTP:jasher1_at_tampabay.rr.com]Sent:	Tuesday, November 13, 2001 9:35 PMTo:	Multiple recipients of list ORACLE-LSubject:	Failures in creating Oracle database file.  I'm attempting to create a 3GB file on an XFS filesystem using Oracle 8irunning on RedHat 7.1 with a generic 2.4.10 kernel and I'm getting someerrors.  Here's the command and output I'm getting: CREATE TABLESPACE ALTUSER DATAFILE'/export/4/oracle/oradata/alt/data01.dbf' SIZE 3000M REUSE AUTOEXTEND ONNEXT 1280K MINIMUM EXTENT 128K DEFAULT STORAGE ( INITIAL 128K NEXT 128K MINEXTENTS 1MAXEXTENTS 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 limitis 4GB which is why I made the file 3GB.  Is this correct or am I missingsomething??  Many thanks!!   -- Jesse W. Asher              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                Received on Tue Nov 13 2001 - 23:45:14 CST