OraFAQ Forum: General » Undo Tablespace not regaining space

Home » Other » General » Undo Tablespace not regaining space (Oracle 10g)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Undo Tablespace not regaining space [message #393347]

Sat, 21 March 2009 21:04

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?

Report message to a moderator

Re: Undo Tablespace not regaining space [message #393348 is a reply to message #393347]

Sat, 21 March 2009 21:24

BlackSwan
Messages: 26766
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/

Report message to a moderator

Re: Undo Tablespace not regaining space [message #393351 is a reply to message #393347]

Sat, 21 March 2009 21:40

Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/undo.htm#ADMIN10180

Report message to a moderator

Re: Undo Tablespace not regaining space [message #393353 is a reply to message #393351]

Sat, 21 March 2009 21:46

ajitpal.s
Messages: 204
Registered: November 2006

Senior Member

i will refer to the link. thank you

Report message to a moderator

Previous Topic:	Oracle DB migration
Next Topic:	How Oracle 11g leverages the features of Multi-core Architectures

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Dec 27 21:24:03 CST 2024