Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

My undo tablespace is full after some modifications. Las column is % of space used.

xxx_undo_01.dbf UNDO 2147483648 16777216 2048 2032 16 0,78 99,22

Now i cannot execute any query according to this. How can i free the undo tablespace ?

Thanks in advance.

share|improve this question
Can you add another datafile to the UNDO tablespace to get you by in the short term? e.g.: ALTER TABLESPACE undotbs_01 ADD DATAFILE '/u01/oracle/rbdb1/undo0102.dbf' AUTOEXTEND ON NEXT 1M MAXSIZE UNLIMITED; Taken from link – Phil Sumner Jan 28 '14 at 14:28
I can't add another datafile. I want to free the undo tablespace. I've all the operations/chages commited. I think it should reduce the data stored after the operations are commited. – Jorge Vega Sánchez Jan 28 '14 at 14:41
What error are you getting when you try to run a query? – Phil Sumner Jan 28 '14 at 15:55

You can execute below query.


share|improve this answer
This should erase also the datafile of the undo tablespace. I only want to free some space. – Jorge Vega Sánchez Jan 28 '14 at 14:48

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.