Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14402: updating partition key column would cause a
partition change
- 2 Answers
- 10574 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-00233: function name used as an exception name in when clause
PLS-00371: at most one declaration for 'string' is permitted in the declaration section
TNS-00275: Navigator: Tracing is now ON
ORA-28535: invalid Heterogeneous Services context
PLS-00364: loop index variable 'string' use is invalid
SQL*Loader-00820: cannot create where clause with range for table string
RMAN-03004: fatal error during execution of command
TNS-00019: INTCTL: error initializing the national language interface
AMD-00130: dimension #string: RDBMS dimension column data type not specified
ORA-35282: (SNSYN166) The format of the AGGREGATE function is: AGGREGATE(varname USING aggmap-name [COUNTVAR intvar-name] [FORCECALC])
ORA-29281: invalid mode
RMAN-06445: cannot connect to recovery catalog after NOCATALOG has been used
Oracle Errors 
