Hello all,
we have a big table that size over than 2 To, partitionned into 12 parts. we want to do an online reorg for a single partition.
at the end of operation we get:
ORA-42012: error occurred while completing the redefinition
ORA-28665: table and partition must have same compression attribute
so i have checked partition configuration and i can see that compress is not activate but is activated for index partition.
i think about one solution, but i don't know if is the good way:
1- delete primary index
2- reorg
3- recreate index
did you think that is a good solution, is not dangerous to delete primary index?
or
is there any option to activate in brspace to skeep compression check?
thank you for your help