Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Failures in creating Oracle database file.

Failures in creating Oracle database file.

From: Jesse W. Asher <jasher1_at_tampabay.rr.com>
Date: Tue, 13 Nov 2001 20:00:39 -0800
Message-ID: <F001.003C4113.20011113193520@fatcity.com>

 

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
 
Received on Tue Nov 13 2001 - 22:00:39 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US