Skip to Main Content
Forums

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!

Which is faster: ALTER MOVE or EXPORT/RECREATE TBS/IMPORT?

user12183454Jan 3 2014 — edited Jan 8 2014

I want to reclaim free space from our tablespaces which are only used monthly. Since this table is aggregated at the end of every month, I'm thinking of reclaiming the free space for this tablespace.

But I want to know which is faster:

ALTER TABLE <table name> MOVE PARTITIONS TABLESPACE <other tablespace>

OR

export --> drop tablespace --> recreate tablespace --> import ?
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Feb 5 2014
Added on Jan 3 2014
#general-database-discussions
23 comments
1,355 views