0

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.

3
  • 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 Commented Jan 28, 2014 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. Commented Jan 28, 2014 at 14:41
  • What error are you getting when you try to run a query? Commented Jan 28, 2014 at 15:55

1 Answer 1

-1

You can execute below query.

DROP TABLESPACE xxx_undo_01 INCLUDING CONTENTS AND DATAFILES;

1
  • This should erase also the datafile of the undo tablespace. I only want to free some space. Commented Jan 28, 2014 at 14:48

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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