Hi, being able to create a file >2GB in OS does not mean being able to create file >2GB in Oracle. Oracle addressing technique may not match OS addresing capabilities. There should be a note on metalink which give oracle-platform matrixes regarding 2GB problem. ----- Original Message ----- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, May 18, 2001 1:41 PM > 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: [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). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: unal-bilisim 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).