ORA-14402: updating partition key column would cause a partition change

SQL> CREATE TABLE honnikery
  2  (
  3    id NUMBER       NOT NULL,
  4    name       VARCHAR2(12) NOT NULL,
  5    name_id   VARCHAR2(30) NOT NULL
  6  )
  7  PARTITION BY LIST (CITY_ID)
  8  (
  9    PARTITION P282 VALUES ('1'),
 10    PARTITION P283 VALUES ('10'),
 11    PARTITION P284 VALUES ('20'));
Table created.
SQL>
SQL> INSERT INTO honnikery VALUES (1,'prabhakr','1');
1 row created.
SQL> INSERT INTO honnikery VALUES (2,'honnikery','1');
1 row created.
SQL> INSERT INTO honnikery VALUES (3,'pawan','1');
1 row created.
SQL> INSERT INTO honnikery VALUES (4,'daivik','1');
1 row created.
SQL> COMMIT;
Commit complete.




SQL> UPDATE honnikery SET name_id = '1' WHERE id = 1;
UPDATE honnikery SET name_id = '1' WHERE id = 1
       *
ERROR at line 1:
ORA-14402: updating partition key column would cause a partition change




SQL> ALTER TABLE honnikery ENABLE ROW MOVEMENT;
Table altered.
SQL>UPDATE honnikery SET name_id = '1' WHERE id = 1;
1 row updated.
SQL> COMMIT;
Commit complete.
SQL> ALTER TABLE honnikery DISABLE ROW MOVEMENT;
Table altered.