The temp tablespace was using all the volume in the diskspace which included the system tablespace. So the physical temp file was deleted. There was not enough disk space to created another temp file,drop the old one and bring back the new one back up
I found note 250064.995 on Metalink, which concerns someone with a very similar problem to yours. He dropped his temporary tablespace with the following commands, after creating a new temporary tablespace.
startup mount
alter database datafile x offline drop;
alter database open;
alter tablespace temp offline immediate;
drop tablespace temp;
If this works, you should then create a new temp ts to replace the one you just dropped.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.