ORA-14402: updating partition key column would cause a
partition change

Answers were Sorted based on User's Feedback



ORA-14402: updating partition key column would cause a partition change..

Answer / virender sharma

alter table <partition name> enable row movement;

after that fire update command it will allow update

Is This Answer Correct ?    5 Yes 0 No

ORA-14402: updating partition key column would cause a partition change..

Answer / guest

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

Action: Do not attempt to update a partition key column or
make sure that the new partition key is within the range
containing the old partition key.

Please add more information about this Error

Is This Answer Correct ?    4 Yes 0 No

Post New Answer

More Oracle Errors Interview Questions

ORA-25145: allocation policy already specified

1 Answers  


SQL*Loader-00416: SDF clause for field string in table string references a non existent field.

1 Answers  


ORA-08463: overflow converting decimal number to Oracle number

1 Answers  


ORA-31015: Attempted to insert entry without name

1 Answers  


ORA-12468: max write level does not equal max read level

1 Answers  






RMAN-08070: deleted datafile copy

1 Answers  


ORA-29537: class or resource cannot be created or dropped directly

1 Answers  


ORA-12156: TNS:tried to reset line from incorrect state

1 Answers  


RMAN-06040: controlfile is already restored to file string

1 Answers  


RMAN-06402: Oracle instance shut down

1 Answers  


PLS-00233: function name used as an exception name in when clause

1 Answers  


ORA-36779: (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.

1 Answers  


Categories