ORA-14402 and global partitioned index
Does the row_movement concept apply to global partitioned indexes which has different partitioning column than the partitioned based table?
In other words, will oracle throw an ORA-14402 if the index (hash) partitioning column is updated that will caused it to hash to a different partition while the table row remains in tact in its current partition?
If yes, I don't see any move_enable syntax for the create index DDL.
There seems to be a lack of Oracle documentation on this. Yes, I know, performing a simple test will provide the answer, but I am thinking someone has probably gone thru this already and I can save a little bit of time. Thanks in advance for any feedbacks or responses
In other words, will oracle throw an ORA-14402 if the index (hash) partitioning column is updated that will caused it to hash to a different partition while the table row remains in tact in its current partition?
If yes, I don't see any move_enable syntax for the create index DDL.
There seems to be a lack of Oracle documentation on this. Yes, I know, performing a simple test will provide the answer, but I am thinking someone has probably gone thru this already and I can save a little bit of time. Thanks in advance for any feedbacks or responses
0