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 segments inside the original tablespace

LaurySep 10 2014 — edited Oct 1 2014

Hi,

Usually, tablespace are shrinked as follow:

1) Move segments from Source tablespace to Target tablespace.

2) Shrink datafile(s) from Source tablespace.

3) Move (re-move) segments from Target tablespace to Source tablespace.

With the last step, segments are "cleanly" ordered in the Source tablespace.

Is it possible to get the same result by to using a Target tablespace but instead moving the segments in the Source tablespace?

Thanks and Regards

Locked Post

New comments cannot be posted to this locked post.

Locked on Oct 29 2014

Added on Sep 10 2014

#general-database-discussions

17 comments

7,466 views