Skip to Content
0
Former Member
Jan 10, 2012 at 01:53 PM

ORA-28665 occured when table single partitioning reorg (2TO) with brspace

482 Views

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