Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14402: updating partition key column would cause a
partition change
- 2 Answers
- 10605 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-07639: smscre: SGA pad area not large enough (string bytes required)
IMG-00836: area queue merge failed
PLS-00235: the external type is not appropriate for the parameter
NZE-28777: binding creation failure
ORA-00315: log string of thread string, wrong thread # string in header
ORA-00292: parallel recovery feature not installed
PLS-00529: Bad column name string in INSERT statement (must be an identifier)
ORA-14125: REVERSE/NOREVERSE may not be specified in this context
TNS-12212: TNS:incomplete PREFERRED_CMANAGERS binding in TNSNAV.ORA
LPX-00653: Output attribute '~S' doesn't have a parent element.
ORA-13384: error in network schema: string
ORA-14307: partition contains too many list values
Oracle Errors 
