Re: Failures in creating Oracle database file.

Thanks for all the replies - I'm not ignoring them. I'm doing some testing now to see what is going on. I'm trying out Oracle 9i since it appears that this may be related to how Oracle was compiled and an innate limitation to Oracle in this case. I should know today if this is the case and will let everyone know....

Tirumala, Surendra wrote:

>In one of my previous assignments, even if my ulimit was unlimited, I could
>not create datafiles bigger than 2 GB,
>The OS was Sun Solaris 2.6. So best thing is to test what Kirti suggested.
>
>Thanks,
>Suren
>
>-----Original Message-----
>Sent: Wednesday, November 14, 2001 12:25 AM
>To: Multiple recipients of list ORACLE-L
>
>
>
>I checked the ulimit and it is set to "unlimited" so I don't think that is
>the problem. I think it is a little more insidious than that....
>
>Deshpande, Kirti wrote:
>
>
>Sounds like a large file can not be created in the file system (the large
>file option at FS level?) or your 'ulimit' is not set large enough to handle
>large sized files.
>
>- Kirti
>
>
>-----Original Message-----
>From: Jesse W. Asher [ SMTP:jasher1_at_tampabay.rr.com
><mailto:SMTP:jasher1_at_tampabay.rr.com> ]
>Sent: Tuesday, November 13, 2001 9:35 PM
>To: Multiple recipients of list ORACLE-L
>Subject: Failures in creating Oracle database file.
>
>
>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!!
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Jesse W. Asher
  INET: jasher1_at_tampabay.rr.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).