Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » lost temp data file
lost temp data file [message #215593] Tue, 23 January 2007 00:52 Go to next message
dirish
Messages: 232
Registered: November 2006
Senior Member
Hi Friends,

By mistake I have deleted the temp.dbf in oracle database. How can I proceed as definitely am unable to start my database.

Thanks,
Dirish
Re: lost temp data file [message #215594 is a reply to message #215593] Tue, 23 January 2007 00:58 Go to previous message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Hi,

Don't warry about temp.dbf tempfile.
you can create new one.

If process of open your database your not getting any error because of missing tempfile.
you have to just drop old ( missing) temp file. and create new file.

first open your database.
1.ALTER DATABASE TEMPFILE '/u02/oracle/data/temp01.dbf' DROP 
   INCLUDING DATAFILES;

2.ALTER tablespace TEMP
add TEMPFILE 'path' size xxxM
autoextend off
/



regards
Taj
Previous Topic: XA error in websphere 6 when not using XA
Next Topic: Application Server
Goto Forum:
  


Current Time: Thu Mar 28 16:09:00 CDT 2024