Oracle Fix for "NID-00137 All datafiles that..." Error

You need to drop the TEMP files before running this command, You can use the following script to generate drop SQL to resolve this NID-00137 error.

set pagesize 0
set linesize 600
select 'alter database tempfile '''||name||''' drop including datafiles;' as cmd from v$tempfile;