Take the 2-minute tour ×
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. It's 100% free, no registration required.

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 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 at 14:41
    
What error are you getting when you try to run a query? –  Phil Sumner Jan 28 at 15:55

1 Answer 1

You can execute below query.

DROP TABLESPACE xxx_undo_01 INCLUDING CONTENTS AND DATAFILES;

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 at 14:48

Your Answer

 
discard

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.