Jesse:
It sounds as if you may have run into the 2GB file size limit.
Has your filesystem been created and mounted with the "largefiles" option?
An easy way to check would be to try and create the tablepace with a
1GB or 2GB datafile and see if it works.
"Jesse W. Asher" wrote:
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
--
====================================================================
Byron Pearce
mailto:bpearce_at_tenure.com
Tenure Systems, Inc.
Arlington, Texas
"It's hard to be a ninja when you wear a beeper."
Received on Tue Nov 13 2001 - 23:02:41 CST
