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!

anyway to shrink tablespace online?

BingLiuAug 12 2010 — edited Aug 16 2010

I have a 500GB tablespace with 10 files, that was full, after deleting, purge, it is half free now, I want to reduce datafile size, but I can not do "alter database datafile resize...." as some object in the end of the file.

anyway to shrink tablespace/datafiles online?

Thanks!!

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 13 2010

Added on Aug 12 2010

#general-database-discussions

18 comments

4,008 views