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 [EMAIL PROTECTED]
--
====================================================================
Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas"It's hard to be a ninja when you wear a beeper."
