Cant create tablespace

From: <jeff.w.mcclure_at_ameritech.com>
Date: Fri, 12 Jun 1998 19:59:15 GMT
Message-ID: <6ls1aj$cp3$1@nnrp1.dejanews.com>

Folks,

I could use some help! Up 'till last night all was working fine. Don't honestly know what happened. Heres the story:

Situations dictate that I drop and recreate a tablespace (used for temporary objects) on a daily basis. This has been working via script without problem for nearly 6 months now. Last night, it failed. Following is my create statement and the results thereof: (the user doing the create has the DBA role and owns all objects in this tablespace as well as the tablespace itself)

create tablespace alertdata_02
  2 datafile '/u01/oradata/reports/datafile/alertdata_02.dbf' size 50M reuse   3 default storage(

  4          initial 200K
  5          next 200K
  6          pctincrease 1
  7          minextents 1
  8          maxextents 121

  9 )
 10 /
CREATE TABLESPACE ALERTDATA_02
*
ERROR at line 1:
ORA-01119: error in creating database file '/U01/ORADATA/REPORTS/DATAFILE/ALERTDATA_02.DBF' ORA-27040: skgfrcre: create error, unable to create file SVR4 Error: 2: No such file or directory

I checked permissions on all directories - they are all 777 (now). There is 250MB of space available in this filesystem (not that I need it with the reuse clause). I attempted creating in another filesystem with the same results. I can only create the ts by using svrmgr. The one thing that bothers me is that the error message above shows the datafile in ALL CAPS... Is this a clue? I created a directory whose name was in all caps. I could then create the tablespace in that directory (however, it was still named in all caps).

I have created the tablespace using svrmgr and modified scripts accordingly, in order to continue on with daily processing, but I would like to get to the bottom of this and find resolution. Can anyone help? It would be greatly appreciated!

Jeff McClure
Specialist Database Analyst
Ameritech New Media
e-mail: Jeff.W.McClure_at_Ameritech.com

-----== Posted via Deja News, The Leader in Internet Discussion ==----- http://www.dejanews.com/ Now offering spam-free web-based newsreading Received on Fri Jun 12 1998 - 14:59:15 CDT