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).

Reply via email to