Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14402: updating partition key column would cause a
partition change
- 2 Answers
- 10445 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 |
RMAN-08104: input backupset count=string stamp=string creation_time=string
ORA-14096: tables in ALTER TABLE EXCHANGE PARTITION must have the same number of columns
ORA-13913: The threshold cannot be set when SYSAUX is offline.
ORA-08459: invalid format parameter length
ORA-14504: syntax not supported for analyze
ORA-07477: scgcmn: lock manager not initialized.
PLS-00522: MAP methods must return a scalar type.
DGM-16912: Unknown command "string". Try "help"
ORA-13344: an arcpolygon geometry has fewer than five coordinates
ORA-28673: Merge operation not allowed on an index-organized table
ORA-09954: scgcc: unexpected return status to callback of lock close
ORA-24801: illegal parameter value in OCI lob function
Oracle Errors 
