Originally posted by ales
Seems you get in this situation quite often ... http://forums.dbasupport.com/forums/...threadid=29705

* ALTER TABLESPACE TEMP ADD TEMPFILE 'new_temp_file'
* ALTER DATABASE TEMPFILE 'old_temp_file' OFFLINE;
* ALTER DATABASE TEMPFILE 'old_temp_file' DROP;
this is often not possible, as users may have space allocated in the tempfile. Be patient, kill the sessions or restart the database
* go to the OS and remove the old_temp_file
Hi is there a need to drop the datafile?
And ... is it possible to drop a datafile without complication?
I learned that to have fewer datafiles in a Tablespace you have to recreate the whole Tablespace ?


The Actual file deallocates the storage when you alter the storage ( same value )
alter tablespace temp
2 default storage (
3 pctincrease 0);

Orca