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

advertisements

_____________________________________________________________________________________________________________________

Error Description:

Application is getting following error while accessing the partitioned table.

The SQL Exception is: "ORA-14402: updating partition key column would cause a partition change

Normally this error happens after making the partitions to the tables.

Solution Description:

Find out the partitioned tables involved for the particular operation from the application and enable the row movement for those tables which will resolve your issue.

SQL> select table_name, row_movement, partitioned from dba_tables where table_name='PROB_DATA';

TABLE_NAME                     ROW_MOVE PAR

------------------------------ -------- ---

PROB_DATA                      DISABLED NO

SQL> alter table PROB_DATA enable row movement;

Table altered.

_____________________________________________________________________________________________________________________

Website Stats