Results 1 to 2 of 2
  1. #1
    Join Date
    Sep 2013
    Location
    India
    Posts
    246

    Unanswered: unable to delete undo tbsp

    Dear ALL,



    Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit

    Linux 6.2


    Old undo tbsp UNDOTBSP1
    New undo tbsp UNDOTBSP2

    New undo tbsp is active. Not able to delete old undo tbsp as it has one rollback segment as partly available

    i not worreid about the data in that rollback segment i have want to delete and drop undo tbsp1.


    OWNER SEGMENT_NAME TABLESPACE_NAME STATUS
    PUBLIC _SYSSMU3_1723003836$ UNDOTBS1 PARTLY AVAILABLE


    please suggest
    ssumit

  2. #2
    Join Date
    Jun 2004
    Location
    Liverpool, NY USA
    Posts
    2,504
    see the following link to see how to take care of it

    http://www.oracleflash.com/32/Change...-database.html
    Bill
    You do not need a parachute to skydive. You only need a parachute to skydive twice.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •