Oracle DBA, How To, Error, Cause and Action

ORA-01258: unable to delete temporary file string

ORA-01258: unable to delete temporary file string




Cause: A DROP TABLESPACE INCLUDING CONTENTS AND DATAFILES or ALTER DATABASE TEMPFILE DROP INCLUDING DATAFILES operation was not able to delete a temporary file in the database.




Action: Subsequent errors describe the operating system error that prevented the file deletion. Fix the problem, if possible, and manually purge the file.