temp tablespace
807932Jun 15 2011 — edited Jun 15 2011hi 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