alter database create temporary tablespace temp_ tempfile 'D:\temp_.dbf' size 64M; alter database default temporary tablespace temp_; drop tablespace temp; alter database create temporary tablespace temp tempfile 'D:\ORADATA\MYDB\temp01.dbf' size 1024M reuse; alter database default temporary tablespace temp; drop tablespace temp;