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 |
ORA-06562: type of out argument must match type of column or bind variable
ORA-01772: Must specify a value for LEVEL
ORA-16059: Log file is empty or invalid next available block
ORA-12164: TNS:Sqlnet.fdf file not present
NZE-28840: Wallet is already open.
ORA-12828: Can't start parallel transaction at a remote site
ORA-16548: object not enabled
ORA-13709: Required parameter "string" must be set before execution.
NNL-00990: DEFAULT-FORWARDERS-ONLY mode: string
RMAN-06105: duplicate qualifier found in LIST command: string
DRG-11869: Premature End Of File Detected
ORA-25451: too many attribute values for variable: string