Oracle Database Discussions

Hi Oracle-Gurus,

the problem occured when my temp01.dbf file size increase from some MBs to 30GB!! (In a weeks time)
without doing RnD on advice , datafile temp01.dbf was deleted!!!! ,
now a text file was created ,I renamed it withe same name "temp01.dbf" !!!!!!

now my jobs are failing with the error :

1157 : 64000 : java.sql.SQLException: ORA-01157: cannot identify/lock data file 201 - see DBWR trace file
ORA-01110: data file 201: 'C:\ORACLE\PRODUCT\10.2.0\ORADATA\ORCL\TEMP01.DBF'

I tried to add one more datafile to the tablespace as per the below steps:
1. Login to sqlplus as dba(sys user)
2. shutdown; --Database Dismounted and Oracle Instance Shut Down.
3. startup; -- Oracle Instance Started.
4. Executed this query
alter tablespace temp add datafile
'C:\oracle\product\10.2.0\oradata\orcl\TEMP02.DBF' SIZE 32M;

but still the error is pointing to Temp01.

The funny part i noted here that i am not getting the name of the datafile anywhere in the DB.

I executed this below query

SELECT FILE_NAME FROM DBA_DATA_FILES;

and there is no datafile name with "Temp01" or "Temp02"

I am getting the Tablespace name "TEMP" when executing "SELECT TABLESPACE_NAME FROM DBA_TABLESPACES;"

to add more to the above

I tried to delete the datafile with name "TEMP01.DBF"
by executing

alter tablespace temp drop datafile
'C:\oracle\product\10.2.0\oradata\orcl\TEMP01.DBF' ;

i am getting the following error:
ORA-03219: Tablespace 'TEMP' is dictionary-managed, offline or temporary

This tablespace (TEMP) is temporary(Default) and its allocation_type is Uniform


What i am looking for

1. Delete the Temp01 datafile and rename the temp02 with it.
2. Allow the auto extention to renamed datafile along with default features of temp datafile.

Am i at point of no return??...i am new at this level of work..i have been trying to resolve the problem taking refrences from forumns ..but still lacking somwhr..

Need help to resolve this.