Re: Can't drop an unused roll back segment...

  • From: Daniel Fink <daniel.fink@xxxxxxxxxxxxxx>
  • To: po04541@xxxxxxxxx
  • Date: Fri, 14 May 2010 07:36:23 -0600

The message means that there is an active transaction using that undo segment. Until that transaction ends, you cannot drop the tablespace. 


When did you change undo_tablespaces? How did you change undo_tablespaces?

Regards,
Daniel Fink

Daniel Fink

OptimalDBA    http://www.optimaldba.com
Oracle Blog   http://optimaldba.blogspot.com

Lost Data?    http://www.ora600.be/

patrick obrien wrote:
Oracle Admin, (sorry starting a new thread on this but its a bit different from the original)
I'm trying to drop this unused undo tablespace/dbf file. Any thoughts would be greatly appreciated. Patrick OBrien. 

SQL> show parameter undo

NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------ 
undo_management                      string      AUTO
undo_retention                       integer     14400
undo_tablespace                      string      UNDOTBS3

SQL> drop tablespace UNDOTBS1 including contents;
drop tablespace UNDOTBS1 including contents
*
ERROR at line 1:
ORA-01548: active rollback segment '_SYSSMU1$' found, terminate dropping tablespace 


SQL> drop rollback segment "_SYSSMU1$";
drop rollback segment "_SYSSMU1$"
*
ERROR at line 1:
ORA-30025: DROP segment '_SYSSMU1$' (in undo tablespace) not allowed

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 05-2010