updating partition key column would cause a partition change

Solution ID:ORA-14402

Type: Oracle

Cause

An UPDATE statement attempted to change the value of a partition key column causing migration of the row to another partition

Actions

Ensure that all subpartitions specified belong to the same partition.

Try the following links for this error:


http://docs.oracle.com/cd/E16655_01/server.121/e26079/e12700.htm


http://docs.oracle.com/cd/E16655_01/doc.121/e36716/ch2migrasteps.htm


https://community.oracle.com/message/9620125


https://community.oracle.com/message/3718527


https://community.oracle.com/message/1402065


https://community.oracle.com/message/10374494


https://community.oracle.com/message/9060140


https://community.oracle.com/message/1768525


https://community.oracle.com/message/3757596


https://community.oracle.com/message/3670430


https://community.oracle.com/message/1952823


https://community.oracle.com/message/1564357


https://community.oracle.com/message/417652


https://community.oracle.com/message/2058


https://community.oracle.com/message/1126263


https://community.oracle.com/message/9776125


https://community.oracle.com/message/4511210


Browse all solutions to database errors from Oracle, MS SQL, or MySQL