Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14402: updating partition key column would cause a
partition change
- 2 Answers
- 10702 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 |
PLS-00139: duplicate external NAME specification in subprogram expression
ORA-00273: media recovery of direct load data that was not logged
ORA-16164: LGWR network server host detach error
ORA-33072: (XSAGDNGL35) In AGGMAP workspace object, the hierarchy dimension QDR over dimension workspace object must be specified for every relation dimensioned by that hierarchy dimension.
ORA-13027: unable to read dimension definition from string
ORA-06564: object string does not exist
ORA-02083: database name has illegal character 'string'
LSX-00122: value is not valid restriction of parent's whiteSpace
TNS-00549: value specified for the SSL version is not valid
LPX-00115: element "~1S" is missing required attribute "~2S"
ORA-23532: tables with different synchronization mechanisms are in the same group
ORA-01640: cannot make tablespace read only with active transactions
Oracle Errors 
