Antwort: Re: Failures in creating Oracle database file.

Oracle does not support files larger than 2GB on Linux Doesnt matter if linux itself support it or not. Ivo

                                                                                       
                            
                    Byron Pearce                                                       
                            
                    <bpearce_at_tenu        An:     Multiple recipients of list ORACLE-L 
<ORACLE-L_at_fatcity.com>       
                    re.com>              Kopie:                                        
                            
                    Gesendet von:        Thema:  Re: Failures in creating Oracle 
database file.                    
                    root_at_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              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."








-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Ivo.Libal_at_knapp-systems.com

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: ListGuru_at_fatcity.com (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).