Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Cant create tablespace
It looks like maybe when you deleted the datafile it also deleted the
directory it was in. Just a thought.
jeff.w.mcclure_at_ameritech.com wrote in message
<6ls1aj$cp3$1_at_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 Mon Jun 15 1998 - 19:44:34 CDT