UNDOTBS01.DBF too big
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 5 of 5

Thread: UNDOTBS01.DBF too big

  1. #1
    Join Date
    Oct 2004
    Location
    Warminster,PA
    Posts
    10

    UNDOTBS01.DBF too big

    Subject file is getting humongous. What can I delete and do to shrink the file to something under a gig or less. It is over 1 g's and no more disk space. I haven't done anything important in last 2 months (waiting for 8i cert to arrive in mail). If this is where undo or redo history ends up, I could delete all of it as I don't need to keep any of it.

    I aparently turned on the redo history for studying for 8i test and it has been on through many reboots and now there is no more disk space left in the partition.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    first go and read the manuals.

    second, resize the tablespace downwards if you want or create a new one and drop that one.

    3rd delete your archive log files if you dont need them

  3. #3
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142

    Re: UNDOTBS01.DBF too big

    Originally posted by Prayer
    (waiting for 8i cert to arrive in mail)
    If this is an OCP cert, remind me not to bother.

  4. #4
    Join Date
    Apr 2001
    Location
    Brisbane, Queensland, Australia
    Posts
    1,203
    I thought it was a wind-up.
    OCP 8i, 9i DBA
    Brisbane Australia

  5. #5
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Originally posted by grjohnson
    I thought it was a wind-up.
    I fear it's not . . . . http://www.dbasupport.com/forums/sho...threadid=45301

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