Re: Cant create tablespace

It could be because of the 'reuse' clause in 'datafile '/u01/oradata/reports/datafile/alertdata_02.dbf' size 50M reuse'. reuse expects an existing file to reuse. If you do not have that file then remove the reuse clause.

raghuvir

jeff.w.mcclure_at_ameritech.com wrote in article <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 Sat Jun 13 1998 - 00:50:40 CDT