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

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

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

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.