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!

How to move partitions to a new tablespace

The_Cute_DBAJan 25 2023

I would like to explain my scenario using the following details.
I have a ranged partitioned table named PART_TABLE using TRANS_DATE.
It has two global indexes INDEX01 and INDEX02
It has two LOB columns MYLOB01 and MYLOB02
It has five partitions P_2019, P_2020, P_2021, P_2022 and P_MAX
P_2019, P_2020, and P_2021 are stored in OLD_TABLESPACE
P_2022 and P_MAX are stored in NEW_TABLESPACE
What is the best way to move P_2019, P_2020 and P_2021 from OLD_TABLESPACE to NEW_TABLESPACE without impacting transactions and also considering the LOB columns and global indexes?

Comments
Post Details
Added on Jan 25 2023
4 comments
2,263 views