While dropping temp files you might have seen this error. SQL > ALTER DATABASE TEMPFILE  ‘/home/oracle/app/test11/oradata/temp1.dat’  DROP INCLUDING DATAFILES; ALTER … Continue reading ORA-25152: TEMPFILE cannot be dropped at this time