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!

How to reduce size of table/tablespace

585715Jul 16 2007 — edited Jul 16 2007

I am having a problem with harddisk usage since database increases and takes almost harddisk.

The user tablespace which has some tables having big logs and usage percent of this tablespace is 98% (980M/1000M). I deleted lots of logs in some tables, around 500M with my calculation, but percentage usage of this tablespace is still 98% and nothing reduced.

I don't understand why %usage of tablespace didn't reduce after deleting lots of data, and what should I do this case to release free space for harddisk?

Note that I know how to resize tablespace, but in this case resizing 20M (1000-980) has no meaning.

Thanks for all support.

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 13 2007

Added on Jul 16 2007

#general-database-discussions

7 comments

1,662 views