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

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.

DBA Tips Data Pump Reference

0 comments:

Post a Comment

 

dba topics. Copyright 2011-16 All Rights Reserved | Site Map | Contact | Disclaimer | Google