..a little extra..
Stefano Vasi, March 16, 2018 - 9:14 am UTC
Thanks for your reply. Everything is clear.
Mi real issue is that in my environment I've 4 partitioned, and subpartitioned, tables with their indexes where partitions and subpartitions name are the same.
Eg:
TABLE1
PART1
SUBPART1 (Tablespace: T1P1SP1)
SUBPART2 (Tablespace: T1P1SP2)
SUBPART3 (Tablespace: T1P1SP3)
PART2
SUBPART1 (Tablespace: T1P2SP1)
SUBPART2 (Tablespace: T1P2SP2)
SUBPART3 (Tablespace: T1P2SP3)
TABLE2
PART1
SUBPART1 (Tablespace: T2P1SP1)
SUBPART2 (Tablespace: T2P1SP2)
SUBPART3 (Tablespace: T2P1SP3)
PART2
SUBPART1 (Tablespace: COMMONTBS)
SUBPART2 (Tablespace: COMMONTBS)
SUBPART3 (Tablespace: COMMONTBS)
I need to modify, only for TABLE2 > PART2 > SUBPART1-3, with separate tablespaces (T3P2S1, T3P2S2, T3P2S3).
Altering what's in my scenario with the suggested solution will affect all subpartitions named SUBPART1,2 or 3 of the other partitions?
Is a messy world :)
Thanks again
March 16, 2018 - 1:17 pm UTC
I'm not sure what the issue is here?
Rebuilding a subpartition only affects one subpartition. So run three "alter index..." commands to move the three you want to relocate.
Stefano Vasi, March 16, 2018 - 1:24 pm UTC
Nothing wrong.
Simly I had to try it.
And it worked.
Thanks
You saved my day!
March 18, 2018 - 3:02 am UTC
glad we could help
Move Tablespace for SubPartition Indexes
Amin Adatia, June 22, 2023 - 10:18 am UTC
Is it possible to move the subpartition indexes for more than one partition at the same time using two separate jobs.
June 22, 2023 - 2:35 pm UTC
I'm not sure what you mean - please clarify