Interested to Buy Any Domain ? << Click Here >> for more details...
ORA-14402: updating partition key column would cause a
partition change
- 2 Answers
- 10476 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 |
ORA-02436: date or system variable wrongly specified in CHECK constraint
ORA-13440: GeoRaster metadata compression type error
ORA-24191: the property name string has existed
ORA-06413: Connection not open.
NNL-00235: Auto-refresh failure-retry expiration period is now string
DRG-10100: invalid argument found: string
PLS-00668: Type of expression should be a collection type
ORA-08458: invalid format parameter
ORA-12011: execution of string jobs failed
PLS-00570: different number of columns in the multiset and cast expressions
ORA-14068: TABLESPACE and TABLESPACE_NUMBER may not be both specified
NZE-28786: decryption of encrypted private key failure
Oracle Errors 
