ORA-14402: updating partition key

All,

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.

By
Sivaraman

you cannot

but i want to update the values.Please advice...

get the main schema password and update.

Thanks,

Quote:

---

Originally Posted by pvi_siva

but i want to update the values.Please advice...

---

then you need to get row movement enabled