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!

reclaim free space from USERS tablespace

2723794Aug 30 2011 — edited Aug 30 2011

Hi All,

I want to reclaim tablespace's free space. Tablespace let say USERS having total allocated 20G size and outof that only 300MB is occupied. I want to reclaim the rest of the free space. USERS tablespace having two datafile in it. I have go through below links but helpful for single datafile in tablespace.

http://avdeo.com/2008/02/21/reducing-datafile-size-to-recover-free-space-oracle-database-10g/
http://jonathanlewis.wordpress.com/2010/02/06/shrink-tablespace/

if anyone having knowledge how to do it please update me.

Thanks is advance.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 27 2011

Added on Aug 30 2011

#general-database-discussions

7 comments

1,686 views