| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: File size problem.
7.3.4 does not support file sizes larger than 2GB
>From: "Manivannan.M" <manivannan.m_at_tatainfotech.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: File size problem.
>Date: Fri, 18 May 2001 02:41:02 -0800
>
>Hi DBAs,
> We are creating a oracle 7.3.4 database on a sun machine with solaris 8
>installed on it.The problem is that when we try to create a file thru the
>oracle then it does not allow us to crewate files bigger than 2000M
>size.whereas when we do it thru the OS it does create bigfiles
>
>created file thru the OS:
>-------------------------
>Now when we do a mkfile -v 3000M testfile it does create a big file of
>the required size.But then when i try to create a datafile thru oracle
>then it gives an error:
>
>
>creating file thru the oracle:
>------------------------------
>SVRMGR> create tablespace testb datafile '/db1/dbf/test01.dbf' size 3000M;
>create tablespace testb datafile '/db1/dbf/test01.dbf' size 3000M
>*
>ORA-01119: error in creating database file '/db1/dbf/test01.dbf'
>ORA-07358: sfccf: write error, unable to write to file.
>SVR4 Error: 2: No such file or directory
>
>
>what cud be the reason behind this...
>are there any OS specific parameters that need to be modified or could
>there be some problem with the installation???
>
>please reply ASAP
>
>thanks in advance,
>Jothish
>
>
>
>--
>Please see the official ORACLE-L FAQ: http://www.orafaq.com
>--
>Author: Manivannan.M
> INET: manivannan.m_at_tatainfotech.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).
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.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).Received on Fri May 18 2001 - 06:52:02 CDT
 |
 |