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
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.

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


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 

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

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

Current Time: Sat Nov 28 17:38:33 CST 2020