ORA-14402: updating partition key
I am updating the table based on the leading partition key and i got the error message.
ORA-14402: updating partition key column would cause a partition change
i have serched the google, i got below mentioned solution
alter table emp_det ENABLE ROW MOVEMENT;
but i don't have the privileges for row movement.My schema has shadow schema.how to update the values without ENABLE ROW MOVEMENT syntax.
but i want to update the values.Please advice...
get the main schema password and update.
Try hard to get what you like OR you will be forced to like what you get.
then you need to get row movement enabled
Originally Posted by pvi_siva
Click Here to Expand Forum to Full Width