Home » Other » General » Undo Tablespace not regaining space (Oracle 10g)
Undo Tablespace not regaining space [message #393347] Sat, 21 March 2009 21:04 Go to next message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
Hi,

I executed a couple of transaction, some failed, i rollback, and the transaction that went through was successfully commited.

My undo tablespace has 1gb, and it has been a day, its still at 0.01gb, any idea why its not regaining its space back to 1gb?
Re: Undo Tablespace not regaining space [message #393348 is a reply to message #393347] Sat, 21 March 2009 21:24 Go to previous messageGo to next message
BlackSwan
Messages: 25036
Registered: January 2009
Location: SoCal
Senior Member
You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Re: Undo Tablespace not regaining space [message #393351 is a reply to message #393347] Sat, 21 March 2009 21:40 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10672
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/undo.htm#ADMIN10180
Re: Undo Tablespace not regaining space [message #393353 is a reply to message #393351] Sat, 21 March 2009 21:46 Go to previous message
ajitpal.s
Messages: 204
Registered: November 2006
Senior Member
i will refer to the link. thank you
Previous Topic: Oracle DB migration
Next Topic: How Oracle 11g leverages the features of Multi-core Architectures
Goto Forum:
  


Current Time: Sun Dec 04 10:19:00 CST 2016

Total time taken to generate the page: 0.09800 seconds