how to drop one of two temp files
Hi,
I've just inadvertently altered the temp tablespace in a wrong database -
ALTER TABLESPACE TEMP ADD TEMPFILE 'temp_wrong_file.dbf'
SIZE 100M REUSE AUTOEXTEND ON NEXT 10M MAXSIZE 1000M;
I need to drop just this wrong temp file and not the original and correct temp file for the database.
Is this correct :-
alter database tempfile 'temp_wrong_file.dbf' drop including datafiles;
Will this drop just the wrong temp file?
thanks