ORA-01548 & drop Undo tablespace

06. October 2015 Uncategorized 0
Recently I was cloning one RAC database to single instance database, and afterwards I wanted to remove one of the Undo tablespaces. Unfortunately, it didn’t go so smoothly as I expected… SQL> drop tablespace UNDOTBS2 including contents and datafiles; * ERROR at line 1: ORA-01548: active rollback segment \'_SYSSMU39_1583257383$\' found, terminate dropping tablespace Hmmm, ok ...