Cannot Drop undo Tablespace - urgent

[rmadduluri]

Hi guys,

I had a corrupted undo tablespace so I had to do a switch of undo tablespace. Now I cannot drop the old undo tablespace because it has some active rollback segments '_Sys'. How can I drop this undo tablespace which is offline . This undo tablespace is not letting create exports b'se it still trys to read the datafile assoacited to the oldundo tablespace

any help will be graetly appreciated

Thanks

[JDiaz1125]

This should do the trick:

1. ALTER SYSTEM SET undo_retention=0
SCOPE=MEMORY;

2. DROP TABLESPACE 'tablespace_name'
INCLUDING CONTENTS AND DATAFILES;