Originally posted by pando
considering it´s a temp tablespace and tempfiles I dnt think need to recreate the tablespace when you lose a tempfile, I believe you simply add a tempfile to the temp tablespace (9i)
You are right pando, no need to drop tablespace.
Just do this.
Code:
alter database tempfile 'E:\ORACLE\ORA92\BUCHKU\TEMP01.DBF' drop;
alter tablespace temp add tempfile 'E:\ORACLE\ORA92\BUCHKU\TEMP01.DBF' size 10m;