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-25145: allocation policy already specified
SQL*Loader-00416: SDF clause for field string in table string references a non existent field.
ORA-08463: overflow converting decimal number to Oracle number
ORA-31015: Attempted to insert entry without name
ORA-12468: max write level does not equal max read level
RMAN-08070: deleted datafile copy
ORA-29537: class or resource cannot be created or dropped directly
ORA-12156: TNS:tried to reset line from incorrect state
RMAN-06040: controlfile is already restored to file string
RMAN-06402: Oracle instance shut down
PLS-00233: function name used as an exception name in when clause
ORA-36779: (XSPGPOOLOUT) Invalid parameter value. Olap_page_pool_size must be between must be between 2097152 and 2147483647. Olap_page_pool_size remain unmodified.