Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

temp tablespace

807932Jun 15 2011 — edited Jun 15 2011
hi all
I have a question here regarding the temp tablespace. I googled a bit and also searched the documentation to understand some fundas of the temp tablespace.I came to know that default temp tablespace cant be deleted unless you create a temp tablespace, so if we delete the temp datafiles in os level then what will happen(Will system tablespace becomes the temp tablespace?). In case of other tablespaces if we drop the datafiles from os level then it will throw error also during the startup it will tell the datafiles is not found and recovery in needed... so what will happen in case of the temp files? will it throw any error? also i read that recovering the temp tablespace is no possible and only dropping/recreating is possible is it true?

Thanks
kris
This post has been answered by Aman.... on Jun 15 2011
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 13 2011
Added on Jun 15 2011
9 comments
687 views