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!

moving objects in tablespace

609621Apr 5 2009 — edited Apr 7 2009

dear all,

We have a tablespace with 6 datafiles with 30Gb file size each.. now there are only 5Gb of objects stored in that tablespace..So , I need to free up space in that tablespace.. how I can do this ?..am planning to keep one datafile of 30Gb an delete all the remaining to free space up.. is there any way I can able to move all this objects in a single datafile ?

Please suggest me

Kai

Locked Post

New comments cannot be posted to this locked post.

Locked on May 5 2009

Added on Apr 5 2009

#general-database-discussions

9 comments

1,372 views