ORA-14402: updating partition key column would cause a
partition change
- 2 Answers
- 9497 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
ORA-28113: policy predicate has error
ORA-01950: no privileges on tablespace 'string'
DRG-12223: section name string is a reserved name
PLS-00310: with %%ROWTYPE attribute, 'string' must name a table, cursor or cursor-variable
QSM-01072: materialized view, string, and query have different joins between tables, string
ORA-31527: could not find source column string for CDC change table string.string
ORA-13758: "SQL Tuning Set" "string" is in use.
ORA-22166: collection is empty
AUD-00803: internal error while processing WHERE clause
ORA-29959: error in the execution of the string routine for one or more of the index partitions
PLS-00415: 'string' is an OUT parameter and cannot appear in a function
NNL-00303: Server checking for reload
Oracle Errors 
