| lost temp data file [message #215593] |
Tue, 23 January 2007 00:52  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
