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.

I have a development environment in which I frequently copy a certain schema.

When I'm done with the copy, I will use OracleEM to drop that user/schema.

My problem is that this does not seem to reclaim the space that the schema was occupying from my tablespace file.

I read doing an DROP SCHEMA .... CASCADE would do this, but the users are already deleted.

Now my entire drive is filled up.

How can I reclaim this space now?

share|improve this question
add comment

1 Answer 1

I don't think there's much value in me copying what others have done so well in explaining in the past, so I'll just point you at a brilliant blog post: Reclaiming Unused Space in Datafiles.

Essentially you just need to do:

ALTER DATABASE DATAFILE '/path/to/datafile.dbf' RESIZE 111M;
share|improve this answer
add comment

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.