undo tablespace problem , urgent plz?
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: undo tablespace problem , urgent plz?

  1. #1
    Join Date
    Jul 2006
    Posts
    96

    undo tablespace problem , urgent plz?

    to reduce the size of my undo tablespace ' UNDOTBS1' I used the following method..

    CREATED ANOTHER TABLESPACE UNDOTBS2;

    ALTER SYSTEM SET UNDO TABLESPACE = 'UNDOTBS2';
    ALTERED SUCCESSFULLY.

    NOW I WANT TO DROP THE FIRST TABLESPACE , BUT
    WE SHOULD MAKE IT OFFLINE FIRST.

    ALTER TABLESPACE UNDOTBS1 OFFLINE;

    GIVES ORA-30042 CANNOT MAKE OFFLINE

    WHY HAPPEND THIS. PLZ SUGGEST?

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    if its urgent call oracle support, thats what they are there for

  3. #3
    Join Date
    Oct 2008
    Location
    Chandigarh, India
    Posts
    322
    One thing that seems to me is that the previous undo tablespace still contains active undo segments that may be referred in future. Isn't it?

    Y dont u check using v$rollstat and v$rollname

    SELECT a.name,b.status
    FROM v$rollname a, v$rollstat b
    WHERE a.name IN ( SELECT segment_name
    FROM dba_segments)
    AND a.usn = b.usn
    /
    Last edited by mahajanakhil198; 07-16-2009 at 08:33 AM.
    lucky

Posting Permissions

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


Click Here to Expand Forum to Full Width