Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14402: updating partition key column would cause a
partition change
- 2 Answers
- 10610 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 |
NZE-28827: invalid cipher type passed
LSX-00261: invalid character property
TNS-04049: Specified connections do not exist
ORA-13787: missing SQL profile for statement object "string" for tuning task "string"
PCC-01200: You are not authorized to run Pro*C
PCC-02041: CMD-LINE: Option does not exist:
RMAN-06017: initialization of parser failed
ORA-00372: file string cannot be modified at this time
ORA-23344: constraint (string.string) does not exist
ORA-02304: invalid object identifier literal
LPX-00605: Invalid attribute '~1S' in element '~2S'.
ORA-13702: Snapshot IDs specified by the range [string, string] are equal.
Oracle Errors 
