Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Users tablespace - datafile is 24.5 GB, only 1.2Gb used - What should I Do?

738277Jul 3 2012 — edited Jul 4 2012

Hi All,

In my database I have users tablespace and its datafile is users01.dbf. File size is 24.5 GB, but used data is 1.2 GB. I got this information from OEM, see below image:
https://picasaweb.google.com/100555146235257804098/Oracle_a1#5759303022195932370

How can I free the unused 23GB space?

Just to let you know about my background knowledge, I am an OBI report developer.

Thanks!

This post has been answered by CKPT on Jul 3 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 1 2012

Added on Jul 3 2012

#general-database-discussions

26 comments

623 views