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?