Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to drop one of two temp files

user8869798Oct 11 2012 — edited Oct 11 2012
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
This post has been answered by Fran on Oct 11 2012
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Nov 8 2012
Added on Oct 11 2012
8 comments
2,288 views