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 |
QSM-01063: query has a dictionary table or view
NNL-00542: restart [<server_list>] : restart one or more Names servers
ORA-16548: object not enabled
ORA-24015: cannot create QUEUE_TABLE, QUEUE_PAYLOAD_TYPE string.string does not exist
ORA-01486: size of array element is too large
ORA-33313: (DELDENT05) workspace object cannot be deleted because it is the target of an external partition of a partitioned variable.
ORA-30340: illegal dimension name
ORA-02461: Inappropriate use of the INDEX option
PCB-00007: %s
ORA-08232: smsdes: cannot detach from SGA
TNS-01153: Failed to process string: string
ORA-09938: Save of signal handlers failed.