Skip to Main Content

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!

alter table <table_name> move tablespace <new_tablespace> taking long time

user5716448Sep 14 2021

Hi,
Oracle 10g
Finding alter table <table_name> move tablespace <new_tablespace> taking ages on even small tables
Other users out of system.

Any reason this should time e.g. 5 mins for 50 row table.

Thanks

Comments
Post Details
Added on Sep 14 2021
4 comments
258 views