ORA-14402: updating partition key column would cause a
partition change
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-28605: bitmap indexes cannot be reversed
ORA-28579: network error during callback from external procedure agent
ORA-01572: rollback segment 'string' cannot be brought online, string extents exceeded
NNL-01006: META VIOLATION responses received: number
ORA-01721: USERENV(COMMITSCN) invoked more than once in a transaction
TNS-00286: Max Connect Time (secs) : number
TNS-00272: Navigator
ORA-31408: invalid value specified for begin_scn or end_scn
O2F-00314: AS expected but not seen in the INTYPE file
IMP-00033: Warning: Table "string" not found in export file
NNC-00410: invalid preferred server address list
ORA-29523: authorization error for unknown referenced name