Oracle does not support files larger than 2GB on Linux
Doesnt matter if linux itself support it or not.
Ivo
Byron Pearce
<bpearce@tenu An: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
re.com> Kopie:
Gesendet von: Thema: Re: Failures in creating Oracle
database file.
root@fatcity.
com
11/14/2001
05:40 AM
Bitte
antworten an
ORACLE-L
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 [EMAIL PROTECTED]
--
====================================================================
Byron Pearce mailto:[EMAIL PROTECTED]
Tenure Systems, Inc. Arlington, Texas
"It's hard to be a ninja when you wear a beeper."
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
